sqlgrammer.txt

来自「1．简介 本程序是用纯C语言编的一个基于菜单命令行的数据库系统。可以创建多个数据」· 文本 代码 · 共 62 行

		SQL Grammer
语法结构为：
USE <databasename>
语句批
GO

语句批为：
SELECT * FROM <tablename>
[WHERE <columnname> IS <columnvalue>]

DELETE FROM <tablename>
WHERE <columnname> IS <columnvalue>

设现有数据库master
其中表costomer 
-----------------------------
id	name	age
1000	July	20
2000	Cloud	21
3000 	Kendy	21
4000	Tom	20
5000	Darven	21
-----------------------------

举例1：
USE master
SELECT * FROM customer
GO

结果1为：
-----------------------------
1	1000	July	20
2	2000	Cloud	21
3	3000 	Kendy	21
4	4000	Tom	20
5	5000	Darven	21
-----------------------------
举例2：
USE master
SELECT * FROM customer
WHERE id IS 2000
GO

结果2为：
-----------------------------
2	2000	Cloud	21
-----------------------------

举例3：
USE master
DELETE FROM customer
WHERE id IS 2000
SELECT * FROM customer
GO

结果3为：
-----------------------------
1	1000	July	20
2	3000 	Kendy	21
3	4000	Tom	20
4	5000	Darven	21
-----------------------------