1--disable_warnings 2--enable_warnings 3CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 4CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 5CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 6INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 7INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 8INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 9DELETE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 10SELECT * FROM t1 ORDER BY c1; 11SELECT * FROM t2 ORDER BY c1; 12SELECT * FROM t3 ORDER BY c1; 13DELETE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 14SELECT * FROM t1 ORDER BY c1; 15SELECT * FROM t2 ORDER BY c1; 16SELECT * FROM t3 ORDER BY c1; 17DROP TABLE t1,t2,t3; 18CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 19CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 20CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 21INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 22INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 23INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 24DELETE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 25SELECT * FROM t1 ORDER BY c1; 26SELECT * FROM t2 ORDER BY c1; 27SELECT * FROM t3 ORDER BY c1; 28DELETE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 29SELECT * FROM t1 ORDER BY c1; 30SELECT * FROM t2 ORDER BY c1; 31SELECT * FROM t3 ORDER BY c1; 32DROP TABLE t1,t2,t3; 33CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 34CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 35CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 36INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 37INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 38INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 39DELETE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 40SELECT * FROM t1 ORDER BY c1; 41SELECT * FROM t2 ORDER BY c1; 42SELECT * FROM t3 ORDER BY c1; 43DELETE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 44SELECT * FROM t1 ORDER BY c1; 45SELECT * FROM t2 ORDER BY c1; 46SELECT * FROM t3 ORDER BY c1; 47DROP TABLE t1,t2,t3; 48CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 49CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 50CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 51INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 52INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 53INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 54DELETE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 55SELECT * FROM t1 ORDER BY c1; 56SELECT * FROM t2 ORDER BY c1; 57SELECT * FROM t3 ORDER BY c1; 58DELETE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 59SELECT * FROM t1 ORDER BY c1; 60SELECT * FROM t2 ORDER BY c1; 61SELECT * FROM t3 ORDER BY c1; 62DROP TABLE t1,t2,t3; 63CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 64CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 65CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 66INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 67INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 68INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 69DELETE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 70SELECT * FROM t1 ORDER BY c1; 71SELECT * FROM t2 ORDER BY c1; 72SELECT * FROM t3 ORDER BY c1; 73DELETE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 74SELECT * FROM t1 ORDER BY c1; 75SELECT * FROM t2 ORDER BY c1; 76SELECT * FROM t3 ORDER BY c1; 77DROP TABLE t1,t2,t3; 78CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 79CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 80CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 81INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 82INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 83INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 84DELETE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 85SELECT * FROM t1 ORDER BY c1; 86SELECT * FROM t2 ORDER BY c1; 87SELECT * FROM t3 ORDER BY c1; 88DELETE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 89SELECT * FROM t1 ORDER BY c1; 90SELECT * FROM t2 ORDER BY c1; 91SELECT * FROM t3 ORDER BY c1; 92DROP TABLE t1,t2,t3; 93CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 94CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 95CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 96INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 97INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 98INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 99DELETE QUICK t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 100SELECT * FROM t1 ORDER BY c1; 101SELECT * FROM t2 ORDER BY c1; 102SELECT * FROM t3 ORDER BY c1; 103DELETE QUICK t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 104SELECT * FROM t1 ORDER BY c1; 105SELECT * FROM t2 ORDER BY c1; 106SELECT * FROM t3 ORDER BY c1; 107DROP TABLE t1,t2,t3; 108CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 109CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 110CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 111INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 112INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 113INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 114DELETE QUICK t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 115SELECT * FROM t1 ORDER BY c1; 116SELECT * FROM t2 ORDER BY c1; 117SELECT * FROM t3 ORDER BY c1; 118DELETE QUICK t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 119SELECT * FROM t1 ORDER BY c1; 120SELECT * FROM t2 ORDER BY c1; 121SELECT * FROM t3 ORDER BY c1; 122DROP TABLE t1,t2,t3; 123CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 124CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 125CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 126INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 127INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 128INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 129DELETE QUICK t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 130SELECT * FROM t1 ORDER BY c1; 131SELECT * FROM t2 ORDER BY c1; 132SELECT * FROM t3 ORDER BY c1; 133DELETE QUICK t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 134SELECT * FROM t1 ORDER BY c1; 135SELECT * FROM t2 ORDER BY c1; 136SELECT * FROM t3 ORDER BY c1; 137DROP TABLE t1,t2,t3; 138CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 139CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 140CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 141INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 142INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 143INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 144DELETE QUICK t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 145SELECT * FROM t1 ORDER BY c1; 146SELECT * FROM t2 ORDER BY c1; 147SELECT * FROM t3 ORDER BY c1; 148DELETE QUICK t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 149SELECT * FROM t1 ORDER BY c1; 150SELECT * FROM t2 ORDER BY c1; 151SELECT * FROM t3 ORDER BY c1; 152DROP TABLE t1,t2,t3; 153CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 154CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 155CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 156INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 157INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 158INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 159DELETE QUICK t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 160SELECT * FROM t1 ORDER BY c1; 161SELECT * FROM t2 ORDER BY c1; 162SELECT * FROM t3 ORDER BY c1; 163DELETE QUICK t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 164SELECT * FROM t1 ORDER BY c1; 165SELECT * FROM t2 ORDER BY c1; 166SELECT * FROM t3 ORDER BY c1; 167DROP TABLE t1,t2,t3; 168CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 169CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 170CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 171INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 172INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 173INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 174DELETE QUICK t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 175SELECT * FROM t1 ORDER BY c1; 176SELECT * FROM t2 ORDER BY c1; 177SELECT * FROM t3 ORDER BY c1; 178DELETE QUICK t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 179SELECT * FROM t1 ORDER BY c1; 180SELECT * FROM t2 ORDER BY c1; 181SELECT * FROM t3 ORDER BY c1; 182DROP TABLE t1,t2,t3; 183CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 184CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 185CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 186INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 187INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 188INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 189DELETE IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 190SELECT * FROM t1 ORDER BY c1; 191SELECT * FROM t2 ORDER BY c1; 192SELECT * FROM t3 ORDER BY c1; 193DELETE IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 194SELECT * FROM t1 ORDER BY c1; 195SELECT * FROM t2 ORDER BY c1; 196SELECT * FROM t3 ORDER BY c1; 197DROP TABLE t1,t2,t3; 198CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 199CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 200CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 201INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 202INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 203INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 204DELETE IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 205SELECT * FROM t1 ORDER BY c1; 206SELECT * FROM t2 ORDER BY c1; 207SELECT * FROM t3 ORDER BY c1; 208DELETE IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 209SELECT * FROM t1 ORDER BY c1; 210SELECT * FROM t2 ORDER BY c1; 211SELECT * FROM t3 ORDER BY c1; 212DROP TABLE t1,t2,t3; 213CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 214CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 215CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 216INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 217INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 218INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 219DELETE IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 220SELECT * FROM t1 ORDER BY c1; 221SELECT * FROM t2 ORDER BY c1; 222SELECT * FROM t3 ORDER BY c1; 223DELETE IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 224SELECT * FROM t1 ORDER BY c1; 225SELECT * FROM t2 ORDER BY c1; 226SELECT * FROM t3 ORDER BY c1; 227DROP TABLE t1,t2,t3; 228CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 229CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 230CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 231INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 232INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 233INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 234DELETE IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 235SELECT * FROM t1 ORDER BY c1; 236SELECT * FROM t2 ORDER BY c1; 237SELECT * FROM t3 ORDER BY c1; 238DELETE IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 239SELECT * FROM t1 ORDER BY c1; 240SELECT * FROM t2 ORDER BY c1; 241SELECT * FROM t3 ORDER BY c1; 242DROP TABLE t1,t2,t3; 243CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 244CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 245CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 246INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 247INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 248INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 249DELETE IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 250SELECT * FROM t1 ORDER BY c1; 251SELECT * FROM t2 ORDER BY c1; 252SELECT * FROM t3 ORDER BY c1; 253DELETE IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 254SELECT * FROM t1 ORDER BY c1; 255SELECT * FROM t2 ORDER BY c1; 256SELECT * FROM t3 ORDER BY c1; 257DROP TABLE t1,t2,t3; 258CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 259CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 260CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 261INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 262INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 263INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 264DELETE IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 265SELECT * FROM t1 ORDER BY c1; 266SELECT * FROM t2 ORDER BY c1; 267SELECT * FROM t3 ORDER BY c1; 268DELETE IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 269SELECT * FROM t1 ORDER BY c1; 270SELECT * FROM t2 ORDER BY c1; 271SELECT * FROM t3 ORDER BY c1; 272DROP TABLE t1,t2,t3; 273CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 274CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 275CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 276INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 277INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 278INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 279DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 280SELECT * FROM t1 ORDER BY c1; 281SELECT * FROM t2 ORDER BY c1; 282SELECT * FROM t3 ORDER BY c1; 283DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 284SELECT * FROM t1 ORDER BY c1; 285SELECT * FROM t2 ORDER BY c1; 286SELECT * FROM t3 ORDER BY c1; 287DROP TABLE t1,t2,t3; 288CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 289CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 290CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 291INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 292INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 293INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 294DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 295SELECT * FROM t1 ORDER BY c1; 296SELECT * FROM t2 ORDER BY c1; 297SELECT * FROM t3 ORDER BY c1; 298DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 299SELECT * FROM t1 ORDER BY c1; 300SELECT * FROM t2 ORDER BY c1; 301SELECT * FROM t3 ORDER BY c1; 302DROP TABLE t1,t2,t3; 303CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 304CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 305CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 306INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 307INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 308INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 309DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 310SELECT * FROM t1 ORDER BY c1; 311SELECT * FROM t2 ORDER BY c1; 312SELECT * FROM t3 ORDER BY c1; 313DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 314SELECT * FROM t1 ORDER BY c1; 315SELECT * FROM t2 ORDER BY c1; 316SELECT * FROM t3 ORDER BY c1; 317DROP TABLE t1,t2,t3; 318CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 319CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 320CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 321INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 322INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 323INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 324DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 325SELECT * FROM t1 ORDER BY c1; 326SELECT * FROM t2 ORDER BY c1; 327SELECT * FROM t3 ORDER BY c1; 328DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 329SELECT * FROM t1 ORDER BY c1; 330SELECT * FROM t2 ORDER BY c1; 331SELECT * FROM t3 ORDER BY c1; 332DROP TABLE t1,t2,t3; 333CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 334CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 335CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 336INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 337INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 338INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 339DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 340SELECT * FROM t1 ORDER BY c1; 341SELECT * FROM t2 ORDER BY c1; 342SELECT * FROM t3 ORDER BY c1; 343DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 344SELECT * FROM t1 ORDER BY c1; 345SELECT * FROM t2 ORDER BY c1; 346SELECT * FROM t3 ORDER BY c1; 347DROP TABLE t1,t2,t3; 348CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 349CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 350CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 351INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 352INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 353INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 354DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 355SELECT * FROM t1 ORDER BY c1; 356SELECT * FROM t2 ORDER BY c1; 357SELECT * FROM t3 ORDER BY c1; 358DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2; 359SELECT * FROM t1 ORDER BY c1; 360SELECT * FROM t2 ORDER BY c1; 361SELECT * FROM t3 ORDER BY c1; 362DROP TABLE t1,t2,t3; 363 364