有表 A B C D E F GA.id = B.aid = C.aid = D.aid = E.aid = F.aid = G.aid现在要把id为1的数据在所有表中全部删除刚开始写的循环删除 但执行效率太慢了有没有更好的办法使效率更高
解决方案 »
- 急急急,如何将下列格式文件导入数据库中,而且不报错。
- 求助sql的正则表达式
- HQL语句:mysql中怎么比较日期
- hi, 如果uid 属于某个集合要怎么写?
- MySQL建库的问题
- meidawiki遇到的问题,懂得进来指点一下
- MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout ex
- 求一条sql语句
- 如何删除重复数据,保留第一条
- mysql8.0yum安装,启动成功,密码也改了。关机重启。就进不去了。
- 为什么full join 会报错?而right(left) join没问题?在线等。。。
- mysql自增长初始值设定
A.id = B.aid
and
A.id= C.aid
and
A.id= D.aid
and
A.id= E.aid
and
A.id= F.aid
and
A.id = G.aid
A.id = B.aid
and
A.id= C.aid
and
A.id= D.aid
and
A.id= E.aid
and
A.id= F.aid
and
A.id = G.aid
and A.id=1;
DELETE A,B,C,D,E,F,G FROM A,B,C,D,E,F,G WHERE
A.id = B.aid
and
A.id= C.aid
and
A.id= D.aid
and
A.id= E.aid
and
A.id= F.aid
and
A.id = G.aid
AND A.ID=1
贴建表及插入记录的SQL,
FROM A,B,C,D,E,F,G
WHERE A.id = 1
and B.aid =1
and C.aid = 1
and D.aid = 1
and E.aid = 1
and F.aid = 1
and G.aid = 1
delete from a where id=1
..delete from g where aid=1
$sql = 'DELETE FROM A WHERE id=1;DELETE FROM B WHERE aid=1;DELETE FROM C WHERE aid=1;DELETE FROM D WHERE aid=1;DELETE FROM E WHERE aid=1;DELETE FROM F WHERE aid=1;DELETE FROM G WHERE aid=1 ';
shell_exec('mysql -uroot -p1234 aaa -e "'.$sql.'"');
这样就好许多了 这就结贴