DB - jwyx/ForFun GitHub Wiki

Normal form

http://jacki6.iteye.com/blog/774866
http://blog.csdn.net/jokes000/article/details/7521259

MySQL install (brew & mac os x lion)

http://www.andrewsavory.com/blog/2011/2144

MySQL commands:

mysql.server start //start server
mysql -u root //connect to mysql
mysqladmin -u root -p password //change root password with old password prompt

Mysql interactive tool:

select current_user(); // current user
select database(); // current database
show databases; // all databases
use db_name; // change to db_name
show tables; // show all tables in current database
desc table_name; // show schema of table_name
show columns from table_name; // show schema of table_name

Mysql batch commands:

http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

Mysql backup:

mysqldump db_name > db_backup_file.sql // dump db
mysql db_name < db_backup_file.sql // restore db