mysql 如果判断添加是否成功现有table1,table2,table3。现要将table1表导成文本,要判断是否成功,如果成功,将接着导出table2,table3数据select * from table1 into outfile 'c:/table1.txt'
if 成功 then
select * from table2 into outfile 'c:/table2.txt'
if 成功 then
select * from table3 into outfile 'c:/table3.txt'
end if
end if在mysql 如何实现?大伙指点下
if 成功 then
select * from table2 into outfile 'c:/table2.txt'
if 成功 then
select * from table3 into outfile 'c:/table3.txt'
end if
end if在mysql 如何实现?大伙指点下
mysql> select @@error_count;
+---------------+
| @@error_count |
+---------------+
| 0 |
+---------------+
1 row in set (0.00 sec)