I tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command
mysql to start). I noticed today that there is a pretty extensive built in help system in this command.
You can access it by typing
help COMMAND, so for instance if you type
help ALTER TABLE you get a quick reference for constructing an
ALTER TABLE statement.
If you can't remember what command you want to use, then typing
help contents is your friend. It will output:
For more information, type 'help item', where item is one of the following categories: Administration Column Types Data Definition Data Manipulation Functions Geographic features Transactions
So if your looking for that command that outputs all the columns in a table, but don't know what it's called, you[Read more...]