```c
DQL:select *from 表名 where id=10
creat table sc(sno char(11)),
->cno varchar(20),
->cpmo varchar(20),
->;
alter table sc
->add primary key(sno,sno);
```c
一次添加多个值的方法
```c
mysql> insert into test(id) values(6),(7),(8),(9),(10);
```c
添加一行
mysql> insert into test
-> set id=11,
-> name='王美丽'
insert into 表二select * from 表一;
简写方法:省略字段部分,值需和字段一一对应
```c
insert into test values(4,'王五'); //对
insert into test values('王五',4); //不对
```c
省略字段,且只给部分值
```c
insert into test values(5,null);
```c
一次添加多个值的方法:
```c
insert into test(id) values(6),(7),(8),(9),(10);
```c
mysql自有的添加记录的语句
```c
insert into test
-> set id=11,
-> name='王美丽';
```c
insert into 表2 select * from 表1;
create table demo like test;
insert into demo select * from test;
```c