mysql> delete from JBPM4_VARIABLE;
Query OK, 1404 rows affected (0.03 sec)
mysql> delete fromJBPM4_SWIMLANE;
Query OK, 13 rows affected (0.03 sec)
mysql> delete from JBPM4_EXECUTION; # 这里报错是因为表自己给自己设置了外键关联,所以清除外键字段的数据,就可以了
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`jbpm_db`.`JBPM4_EXECUTION`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `JBPM4_EXECUTION` (`DBID_`))
mysql>
mysql> update JBPM4_EXECUTION set INSTANCE_=null,PARENT_=null,SUBPROCINST_=null,SUPEREXEC_=null;
Query OK, 203 rows affected (0.02 sec)
Rows matched: 203 Changed: 203 Warnings: 0
mysql> delete from JBPM4_EXECUTION; # 所有外键关联数据都清除了,现在删除数据可以了。
Query OK, 203 rows affected (0.02 sec)
强制使用主键索引
我让他采用product_goods pg force index(PRI) 强制使用主键索引
WHERE子句的方式效率最高,样例sql:SELECTSQL_NO_CACHE t1.* FROM hwdb.`t_huawei` t1 WHERE t1.`hwid` >=(SELECTFLOOR(RAND() * (SELECT MAX(t2.hwid) FROM hwdb.`t_huawei` t2 ) )) ORDER BYt1.hwid LIMIT 5;