SQL入门(一)
创建表与插入表
以下演示一个创建名为Person表的SQL语法
CREATE TABLE Person
(
ID_P int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
ID_P | LastName | FirstName | Address | City |
---|---|---|---|---|
然后使用以下语句对其进行插入
INSERT INTO tablename VALUES(value);
INSERT INTO Person VALUES(212506,’DINGHAO’,’GU’,’TANGHE’,’NANYANG’);
生成以下表:
ID_P | LastName | FirstName | Address | City |
---|---|---|---|---|
212506 | DINGHAO | GU | TANGHE | NANYANG |
也可以指定列插入,语法如下:
INSERT INTO tablename (columnName) VALUES(value);
示例:
INSERT INTO Person (LastName,FirstName) VALUES(‘WUHAN’,’LI’);
表更新如下:
ID_P | LastName | FirstName | Address | City |
---|---|---|---|---|
212506 | DINGHAO | GU | TANGHE | NANYANG |
(null) | WUHAN | LI | (null) | (null) |