· 8 years ago · Jul 29, 2018, 01:38 PM
1With No Lock Tables MySQL
2CREATE TEMPORARY TABLE IF NOT EXISTS tmpDate
3(
4dates TIMESTAMP,
5values INT,
6ids INT
7);
8
9DROP TABLE IF EXISTS tmpDate;
10CREATE TEMPORARY TABLE tmpDate
11(
12 date s TIMESTAMP,
13 values INT,
14 ids INT
15) ENGINE=MyISAM;