Temporäre Tabellen vom MySQL

  • Beitrags-Autor:
  • Beitrags-Kategorie:Skripte
SET max_error_count=0;
DROP TEMPORARY TABLE IF EXISTS tmpfilter;
CREATE TEMPORARY TABLE tmpfilter (gid INT);
INSERT INTO tmpfilter (SELECT cot_cof_gid FROM task WHERE cot_betreff LIKE '+++ DEMO +++ %');
DELETE FROM files WHERE cof_gid IN (SELECT gid FROM tmpfilter);
OPTIMIZE TABLE files;