INSERT INTO tableA (aaid,bbid) VALUES (45, SELECT ID FROM tableB WHERE id < 10)
把tableB表中，id小于10的，批量插入tableB
生成9条记录
相当于运行9次 insert 语句
可以这么用吗？
把tableB表中，id小于10的，批量插入tableB
生成9条记录
相当于运行9次 insert 语句
可以这么用吗？
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 4045 days ago, the information mentioned may be changed or developed.
 |
1
phx13ye May 12, 2015  1
INSERT INTO tableA (aaid,bbid) SELEC SELECT 45, ID FROM tableB WHERE id < 10
|
|
3
phx13ye May 12, 2015
s/ SELEC//
|
 |
4
laoyuan May 12, 2015 1
INSERT INTO tableA (aaid,bbid) (SELECT 45, ID FROM tableB WHERE id < 10)
|
 |
5
Septembers May 12, 2015 via Android
|
|
6
laoyuan May 12, 2015
@Septembers 据说看完文档就可以干DBA了
|
Select Language