Lines Matching refs:exec
25 $db->exec('DROP TABLE IF EXISTS test');
29 … $db->exec(sprintf('CREATE TABLE test(id INT, col1 CHAR(10)) ENGINE=%s', PDO_MYSQL_TEST_ENGINE));
38 $db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
42 $db->exec('ALTER TABLE test MODIFY id INT AUTO_INCREMENT PRIMARY KEY');
47 @$db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
51 $db->exec("INSERT INTO test(id, col1) VALUES (101, 'b')");
55 $db->exec('ALTER TABLE test MODIFY col1 CHAR(10) UNIQUE');
57 $db->exec("REPLACE INTO test(col1) VALUES ('b')");
71 $db->exec("INSERT INTO test(col1) VALUES ('c'), ('d'), ('e')");
80 $db->exec('LOCK TABLE test WRITE');
95 $db->exec("INSERT INTO test(col1) VALUES ('z')");
105 @$db->exec('UNLOCK TABLE test');
