mysql语句中如何将数据同时插入到两张表中
A表中的a,b,c三个字段B表中:ID,d,e 三个字段 (B表中的ID自动生成)
C表中:ID,f 两个字段(C表中的ID要获得B表中的ID)要将A(a,b)导入B(d,e);A(c)导入C(f) 同时C.ID=B.ID
SQL语句怎样编写,请高手帮忙下
A表中的a,b,c三个字段B表中:ID,d,e 三个字段 (B表中的ID自动生成)
C表中:ID,f 两个字段(C表中的ID要获得B表中的ID)要将A(a,b)导入B(d,e);A(c)导入C(f) 同时C.ID=B.ID
SQL语句怎样编写,请高手帮忙下
-- C.ID=B.ID 做一个循环函数即可
CREATE TABLE g_a(a INT(5),b INT(5),c INT(5));
CREATE TABLE g_b(id INT AUTO_INCREMENT, d INT(5),e INT(5),PRIMARY KEY(id));
CREATE TABLE g_c(id INT, f INT(5));
INSERT INTO g_a VALUES(1,1,1);
INSERT INTO g_a VALUES(1,1,2);
INSERT INTO g_a VALUES(1,1,3);
INSERT INTO g_a VALUES(1,1,4);
INSERT INTO g_a VALUES(1,2,1);
SELECT * FROM g_a
INSERT INTO g_b(d,e) (SELECT b,c FROM g_a);
SELECT * FROM g_b;
INSERT INTO g_c(f) (SELECT c FROM g_a);
SELECT id FROM g_b WHERE d = 1 AND e = 1
我的意思是B表中导入一条数据后自动生成的id 。 B.id 要导入到C表的id中 INSERT INTO g_c(id,f) (SELECT g_a.c,g_b.id FROM g_a g_b);