Mysql command line

Scrappychimow

Hi, I am writing a report and i am wondering how can i copy a paste a table from mysql command line into a ms word document. I have seen an essay before where the table including dashed lines appear in a document.

Thanks

magooly

http://windows.microsoft.com/en-IE/windows7/products/features/snipping-tool

daymobrew

Or press Alt+Print Screen to copy the MySQL command line window to the clipboard and then paste it into your document.

Beano

would this not do you?

http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format

Scrappychimow

Beano wrote: »

would this not do you?

Thanks but i like the look of the original table.

Graham

Which part are you struggling with, showing the table info or getting the table info into your document?

From the MySQL command line, this will list all of the tables:

show tables;

To output the details for a specific table (probably goes without saying but replace TableNameHere with a real table name).

desc TableNameHere;

You will end up with something like this:

+--------------+------------------+------+-----+-------------------+----------------+
| Field        | Type             | Null | Key | Default           | Extra          |
+--------------+------------------+------+-----+-------------------+----------------+
| somestuff_id | int(10) unsigned | NO   | PRI | NULL              | auto_increment |
| name         | varchar(50)      | NO   |     | NULL              |                |
| value        | varchar(50)      | NO   |     | NULL              |                |
| ts_updated   | timestamp        | YES  | MUL | CURRENT_TIMESTAMP |                |
+--------------+------------------+------+-----+-------------------+----------------+
4 rows in set (0.00 sec)

Then use cut & paste as normal to transfer the output into your document.

Talisman

Are you looking for the text formatted output? If you want something cleaner then you could use MySQL for Excel provided you have Office 2007 or later and import the content to Excel. Transferring it from there to Word is a simple copy and paste.

red_bairn

Download Lightshot and take a screenshot of the table on the command line.