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
| What this info useful to you? You can donate to say thanks |
Add a comment
Sign in to add a comment