创建数据库: create datebase <name>;
确认使用的数据库: use <name>;
创建表: CREATE TABLE sales_rep( employee_number INT, SURNAME VARCHAR(40), first_name VARCHAR(30), commission TINYINT );
列出数据库中现有的表:show tables;
显示表结构: describe <table_name>;
向表中添加新纪录:insert into sales_rep(employee_number,SURNAME,first_name,commission) values(2,'liu','xing',15);
insert into sales_rep values(2,'liu','xing',15);
同时向表中加入多条记录:insert into sales_rep(employee_number,SURNAME,first_name,commission) values(2,'liu','xing',15),(3,'xing','qi;,18),(4,'hua','yang',19);
从表中查询信息:select * from sales_rep where surname='liu';
分类:select * from sales_rep order by commission desc;