Best way to include table (of data) in a question [duplicate]

Question

I would like to ask a question on Stack Overflow which includes a table of data from a MySQL database. What is the best way to include a table of data in a question?

Answer 1

Some people like ASCII Art. Though it's annoying to type in:

| Username  | Password  | Email_Addr |
--------------------------------------
| Username1 | Password1 | Email 1    |
| Username2 | Password2 | Email 2    |
| Username3 | Password3 | Email 3    |
| Username4 | Password4 | Email 4    |
| Username5 | Password5 | Email 5    |

Answer 2

As someone that answers a lot of SQL questions the best way In my opinion to include a table of data is as follows.

CREATE TABLE foo
(
Username varchar(20) PRIMARY KEY,
Password varchar(30),
Email_Addr varchar(100)
)

INSERT INTO foo
SELECT 'Username1','Password1','Email 1' UNION ALL
SELECT 'Username2','Password2','Email 2' UNION ALL
SELECT 'Username3','Password3','Email 3' UNION ALL
SELECT 'Username4','Password4','Email 4' UNION ALL
SELECT 'Username5','Password5','Email 5' 

It gets tedious very quickly adding quotes onto strings, inserting commas and removing vertical bars, underscores and other such artefacts in order to set up a test table to answer the question.

Answer 3

If you don't want to create ASCII art you could upload an image. Simply create the table yourself (spreadsheets work well for this) and then upload a screenshot of the table.

Another route would be to create a table in a google spreadsheet and then use the publish as a web page option to create a link to it.