Extracting a table definition from the command line

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

How can I quickly extract a table definition from my mysql database?

Answer:

Use the commandline tool mysqldump as shown below. The example extracts the table named 'users' from a database named production.


	// -d = no data; structure only // put in your own login information mysqldump production users -d -u root -p password

Comments:

NEW: Optional: Register Login Email address (not necessary): Rate as	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.

	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material. Add a picture: