怎样同时在两个表里插入数据 两个表 A,B A里有个id,email B里有个sid,wb在A里插入id,email同时在B里插入sid,wbA.ID=B.sid 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 版本>5的话,用trigger可以实现 == 思想重于技巧 == 以下摘自 MySQL 5.1 Reference ManualCREATE TABLE test1(a1 INT);CREATE TABLE test2(a2 INT);CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);CREATE TABLE test4( a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b4 INT DEFAULT 0);DELIMITER |CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END;|DELIMITER ;INSERT INTO test3 (a3) VALUES (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL);INSERT INTO test4 (a4) VALUES (0), (0), (0), (0), (0), (0), (0), (0), (0), (0); == 思想重于技巧 == 建议你先下载一下mySQL的手册http://dev.mysql.com/doc/refman/5.0/en/ == 思想重于技巧 == mysql中怎么把一列的值赋值到另一列中 mysql数据导入数据库语句 pgsql--------------------------------批处理 Commit exception overridden by rollback exception 日期转换字符 mysql创建中文表时总是出错 如何在 MySQL 系统提示符下改变用户? MySQL中如何实现两个表的查询? linux+php+apache+PostgreSQL连接数据库出错,请高手指教 查詢數據該怎麽寫 mysql数据库显示中文,在ASP表单传送和显示正常的中文,但mysql显示乱码?? 如何制作一个MySQL5.0的存储过程
CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
b4 INT DEFAULT 0
);DELIMITER |CREATE TRIGGER testref BEFORE INSERT ON test1
FOR EACH ROW BEGIN
INSERT INTO test2 SET a2 = NEW.a1;
DELETE FROM test3 WHERE a3 = NEW.a1;
UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
END;
|DELIMITER ;INSERT INTO test3 (a3) VALUES
(NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL), (NULL), (NULL), (NULL);INSERT INTO test4 (a4) VALUES
(0), (0), (0), (0), (0), (0), (0), (0), (0), (0);
http://dev.mysql.com/doc/refman/5.0/en/