$sql_creat = "CREATE TEMPORARY TABLE test_table(id BIGINT(100) NOT NULL )TYPE = HEAP;";$sql_insert = "INSERT INTO test_table VALUES(1),VALUES(2),VALUES(3);";$sql = "DELETE FROM user WHERE user.id = test_table.id;";怎么简化以上的sql ??
调试欢乐多
你在mysql中怎样同时执行多条mysql语句啊? 就是用 delimiter 命令嘛
PHP中执行SQL代码是一样的啊,就是用“”括起来而已所以
$sql_delim = "delimiter !";$sql_creat$sql_delim.= "INSERT INTO test_table VALUES(1),VALUES(2),VALUES(3);";$sql_creat$sql_delim.= "DELETE FROM user WHERE user.id = test_table.id;";$sql_creat$sql_delim.= "!";执行完后再 delimiter ; 还原
建表 CREATE TEMPORARY TABLE .... 这是一次性工作,执行后就不需要再做了
删除内容 DELETE FROM user .... 这是非经常性工作
插入数据 INSERT INTO test_table ..... 这是经常性工作把他们融合在一起非但是高效率,反而是败招
CREATE TEMPORARY TABLE test_table(id BIGINT(100) NOT NULL )TYPE = HEAP;
INSERT INTO test_table VALUES(1),VALUES(2),VALUES(3);
DELETE FROM user WHERE user.id = test_table.id;
HERE_DOC;
如果做一个大批量的删除或更新怎么写? 不是一条条sql循环,想写成一条sql
DELETE FROM `menu` WHERE `mid` = 1 LIMIT 1;
DELETE FROM `menu` WHERE `mid` = 2 LIMIT 1;
DELETE FROM `menu` WHERE `mid` = 3 LIMIT 1;我看到phpmyadmin里批量删除是这样写的,晕死