5.3数据库原理上课内容

use demol

select * from test;

insert into test values(4,'王五');

select * from test;

insert into test values(5,null);

 select * from test;

insert into test(id) values(6),(7),(8),(9),(10);

 select * from test;

 insert into test
    -> set id=11,
    -> name='王美丽';

 select * from test;

 create table demo like test;

 desc demo;

 select * from demo;

  insert into demo select * from test;

 select * from demo;