DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Extracting a table definition from the command line

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

Generated 16:00:32 on Feb 19, 2018