SQL_脚本

--create database ShuJuKu
--use ShuJuKu
--create table Biao(ID int not null primary key, Lie_1 char(10), Lie_2 varchar(20))
--drop table if exists Biao
--alter table Biao add primary key(ID)
--insert into Biao(ID, Lie_1, Lie_2) values(5, 'char_5', 'varchar_5')
--insert into Biao(ID) values(3)
--update Biao set Lie_1 = 'char_3', Lie_2 = 'varchar_3' where ID = 3
--select top 2 * from Biao
--delete from Biao where ID = 4
--select * from Biao where Lie_1 like '%5%'
--select * from Biao join YongHu on Biao.ID = YongHu.ID
--select * from Biao, YongHu where Biao.ID = YongHu.ID