我有很多SQL insert/update/delete语句,其中有些是多余的。例如,我可能有以下类型的冗余:INSERT INTO "foo" ("id", ...)DELETE FROM "foo" WHERE "id" = 123INSERT INTO "foo" ("id", "col", ...)换句话说,像PostgreSQL、MySQL这样的数据库在实际
DELETE FROM foo WHERE id IN (52000,52001,52002,52003,52004,52005,52006,52007,52008,52009,52010) DELETE FROM modification WHERE fooId = 52010 DELETE FROM otherfoo WHERE fooId = 52010
如果有人知道怎样才能更快,我想优化我的Doublon checker。$doublonchecker="delete bad_rows.* from eMail as good_rows inner join eMail as bad_rows on bad_rows.EMAIL= good_rows.EMAIL and bad_rows.EMAIL_ID > good_rows.EMAIL_ID";
$resultdoublon = mysql_query($doublonchecker$resultdoublo
我注意到,在对最后几行执行delete语句并运行优化表后,自动增量将降回max(id)+1。Increment is: 151, INSERT ROW (id 151)Auto Increment is: 154
DELETE编辑:我刚刚尝试过,当我重新启动mysql服务而不是优化表时也会发生同样的事情。
我正在尝试优化我的查询,我有以下代码:$counter = mysql_query("SELECT COUNT(*) AS c FROM table");$count= $row["c"];mysql_query("DELETE FROM table");?FROM table) else null end