一条insert语句如何插入两条数据?
给个例子
给个例子
解决方案 »
- 怎么给一个blob字段插入一个图片
- mysql如何生成随机码?
- 数据库同步问题,发现一个新问题,请指点!!!!
- 日期比大小该怎么写?
- 请教一个MYSQL 修改字段内容的问题
- 怎么样从mysql表中找出所有某个字段值相同的记录
- 新手问题,vc 编译Mysql的例子程序时提示,提示Cannot open include file: 'my_alloc.h',在线等,立刻结贴
- 如何从Oracle转到MySQL?
- 如何使用,MYSQL中的MySqlManager.exe管理工具? 还望大家拨刀相助!!
- jsp and mysql ?tomcat and apache?中国人不会JSP????
- MySQL问题
- MySQL问题
Query OK, 0 rows affected (0.09 sec)mysql> insert into testdate values(1, '2010-04-11', 15);
Query OK, 1 row affected (0.03 sec)mysql> select * from testdate;
+----+------------+------+
| id | startdate | days |
+----+------------+------+
| 1 | 2010-04-11 | 15 |
+----+------------+------+
1 row in set (0.00 sec)
mysql> insert into testdate values(2, '2010-05-11', 10), (3, '2010-06-29', 1);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0mysql> select * from testdate;
+----+------------+------+
| id | startdate | days |
+----+------------+------+
| 1 | 2010-04-11 | 15 |
| 2 | 2010-05-11 | 10 |
| 3 | 2010-06-29 | 1 |
+----+------------+------+
3 rows in set (0.00 sec)
(
hid int not null,
haname varchar(50) not null
);insert into haha(hid,haname) values (1,'haha'),(2,'hehe')select * from haha恩,可以的,本人亲手试过
(
hid int not null,
haname varchar(50) not null
);insert into haha(hid,haname) values (1,'haha'),(2,'hehe')select * from haha
有效,那个sql-yag 的客户端导出sql时,也是按这种格式导出的。