Browse - Computer Tips - What are some basic mysql commands?

Date: 2010jul21
Product: mysql

Q. What are some basic mysql commands?

A.

mysql <database> Start mysql in a database show tables List all the tables describe <table> Show info about a table source <script> Run sql commands from the named script exit Get out alter table <table> drop <field> Delete a field from a table alter table <table> drop index <index> Delete an index
More on mysql http://www.davekb.com/search.php?target=mysql