#MySQL notes
#step01 - install MySQL:
link: http://www.mysql.com/downloads/|pls choose 'MySQL Community Edition (GPL)’
#step02 - begin to use:
Open terminal first
-> /usr/local/mysql-5.6.19-osx10.7-x86_64/bin/mysql -u root
-> show datanases; -> create database TESTdb; -> show tables;
-> create table table01 ( title VARCHAR(128), type VARCHAR(16), year CHAR(4), id INT UNSIGNED NOT NULL AUTO_INCREMENT KEY) ENGINE MyISAM;
-> describe table01;
-> alter table table01 drop id;
-> INSERT INTO table01(title, type, year) VALUES('The Old Curiosity Shop','Fiction','1841’);
->select * from table01;