mysql临时表插入数据问题 mysql 5.1版本临时表A,临时表B ,结构一样insert into A(C1,C2) select C1,C2 from B limit 10;--- limit 10 报错。请教,怎么改才能limit呢?在线等解答 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table c as select C1,C2 from B limit 10;insert into A(C1,C2) select * from c; insert into A(C1,C2) select * from (select C1,C2 from B limit 10) insert into A(C1,C2) select * from (select C1,C2 from B limit 10) r INSERT INTO A SELECT * FROM (SELECT C1,C2 FROM B limit 10)t; mysql> select * from tb_1;+------+--------+----------+| id | userid | friendid |+------+--------+----------+| 0 | 1 | 3 || 1 | 1 | 4 || 2 | 2 | 3 || 3 | 2 | 6 || 4 | 3 | 5 || 5 | 3 | 6 || 6 | 4 | 5 || 7 | 4 | 2 || 8 | 5 | 2 || 9 | 5 | 7 || 10 | 6 | 7 || 11 | 6 | 8 |+------+--------+----------+12 rows in set (0.04 sec)mysql> create table tb_2 like tb_1;Query OK, 0 rows affected (0.18 sec)mysql> insert into tb_2 select * from tb_1 limit 5;Query OK, 5 rows affected (0.05 sec)Records: 5 Duplicates: 0 Warnings: 0我这个是可以的。 mysql订单表主键的自动生成 关于binlog_format=mixed时,什么时候使用row-based logging 存储过程返回了俩个结果集,如果才能返回一个? mysql无法启动,err日志错误,急,请教 两个表left outer join 这样一段查询为什么会有空值 求助一个mysql统计语句,谢谢 吐槽一下Mysql !!! 差点让他搞崩溃 MySql 存储过程使用游标循环插入数据问题 MySQL查询结合thinkPHP模板渲染的问题 mysql自定义变量无法求和 mysqldump远程的问题 请教sql怎么处理连续登陆日期的最小值。
insert into A(C1,C2) select * from c;
+------+--------+----------+
| id | userid | friendid |
+------+--------+----------+
| 0 | 1 | 3 |
| 1 | 1 | 4 |
| 2 | 2 | 3 |
| 3 | 2 | 6 |
| 4 | 3 | 5 |
| 5 | 3 | 6 |
| 6 | 4 | 5 |
| 7 | 4 | 2 |
| 8 | 5 | 2 |
| 9 | 5 | 7 |
| 10 | 6 | 7 |
| 11 | 6 | 8 |
+------+--------+----------+
12 rows in set (0.04 sec)mysql> create table tb_2 like tb_1;
Query OK, 0 rows affected (0.18 sec)mysql> insert into tb_2 select * from tb_1 limit 5;
Query OK, 5 rows affected (0.05 sec)
Records: 5 Duplicates: 0 Warnings: 0我这个是可以的。