SQL insert 语句

来源：互联网发布：discuz数据调用编辑：程序博客网时间：2024/06/06 19:53

A=> insert into Websites values('6','BaiDu','https://www.baidu.com/','666','CN');
INSERT 0 1
A=> select * from Websites;
id | name | url | alexa | country
----+----------------------+----------------------------------------------------+-------+------------
2 | TaoBao | https://www.taobao.com/ | 13 | CN
1 | Google | https://www.google.com/ | 1 | USA
3 | CaiNiao | http://www.runoob.com/ | 4689 | CN
4 | WeiBo | http://www.weibo.com/ | 20 | CN
5 | FaceBook | http://www.facebook.com/ | 3 | USA
6 | BaiDu | https://www.baidu.com/ | 666 | CN
(6 rows)

insert into Websites(id,name,url,alexa,country) values('7','FaceBook','https://www.facebook.com/','755','USA');
INSERT 0 1
A=> select * from Websites;
id | name | url | alexa | country
----+----------------------+----------------------------------------------------+-------+------------
2 | TaoBao | https://www.taobao.com/ | 13 | CN
1 | Google | https://www.google.com/ | 1 | USA
3 | CaiNiao | http://www.runoob.com/ | 4689 | CN
4 | WeiBo | http://www.weibo.com/ | 20 | CN
5 | FaceBook | http://www.facebook.com/ | 3 | USA
6 | BaiDu | https://www.baidu.com/ | 666 | CN
7 | FaceBook | https://www.facebook.com/ | 755 | USA
(7 rows)

INSERT INTO 语句可以有两种编写形式。

第一种形式无需指定要插入数据的列名，只需提供被插入的值即可：

INSERT INTO table_name
VALUES (value1,value2,value3,...);

第二种形式需要指定列名及被插入的值：

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

A=> insert into Websites(name,url,alexa) values('JingDong','https://www.jingdong.com/','999');
INSERT 0 1
A=> select * from Websites;
id | name | url | alexa | country
----+----------------------+----------------------------------------------------+-------+------------
2 | TaoBao | https://www.taobao.com/ | 13 | CN
1 | Google | https://www.google.com/ | 1 | USA
3 | CaiNiao | http://www.runoob.com/ | 4689 | CN
4 | WeiBo | http://www.weibo.com/ | 20 | CN
5 | FaceBook | http://www.facebook.com/ | 3 | USA
6 | BaiDu | https://www.baidu.com/ | 666 | CN
7 | FaceBook | https://www.facebook.com/ | 755 | USA
| JingDong | https://www.jingdong.com/ | 999 |
(8 rows)

省略缺省值，就只插入没有省略的列值。

阅读全文

0 0