September 08, 2011

Mysql command line basics

show databases;
use db_name; 
show tables; 
describle table_name;
These will get you enogh info to run your real SQL command..
The other way is just to use the UI app eg. MySQL Query Browser