1.查看當(dāng)前數(shù)據(jù)庫(kù)中所有表格
- show tables;
2.在當(dāng)前數(shù)據(jù)庫(kù)中建表
create table student (表格名)（
sid varchar(12),
name varchar(20),
sex char(4),
age int
);
3.查看表格的結(jié)構(gòu)
- desc student;
4.插入數(shù)據(jù)到表格中
insesrt into student values('2017-c001','帥哥','男',55 );
insesrt into student values('2017-c001','美女','女',55 );
5.查看當(dāng)表格中的所有數(shù)據(jù)
- select * from student;
