mysql入门记录

mysql -h localhost(or ID) -u root -p

 

show databases;

create database <数据库名>；

drop database <数据库名>；

use pythontest;

describe tb01;

create table tb01(id int,name char(32));

insert into tb01 values(1,"test");

select  * from tb01;

select name, id from tb01 where id =1;

http://www.cnblogs.com/linjiqin/archive/2013/03/01/2939384.html