Lines Matching refs:exec
24 $db->exec('DROP TABLE IF EXISTS test');
28 … $db->exec(sprintf('CREATE TABLE test(id INT, col1 CHAR(10)) ENGINE=%s', PDO_MYSQL_TEST_ENGINE));
37 $db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
41 $db->exec('ALTER TABLE test MODIFY id INT AUTO_INCREMENT PRIMARY KEY');
46 @$db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
50 $db->exec("INSERT INTO test(id, col1) VALUES (101, 'b')");
54 $db->exec('ALTER TABLE test MODIFY col1 CHAR(10) UNIQUE');
56 $db->exec("REPLACE INTO test(col1) VALUES ('b')");
70 $db->exec("INSERT INTO test(col1) VALUES ('c'), ('d'), ('e')");
79 $db->exec('LOCK TABLE test WRITE');
94 $db->exec("INSERT INTO test(col1) VALUES ('z')");
104 @$db->exec('UNLOCK TABLE test');
