/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_closecursor_empty.phpt | 61 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_stmt_errorcode.phpt | 15 $db->exec('DROP TABLE IF EXISTS ihopeitdoesnotexist');
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 29 $db->exec('DROP TABLE test'); 51 $db->exec('DROP TABLE test');
|
H A D | pdo_mysql_stmt_fetch_non_select.phpt | 73 if ($db->exec("PREPARE mystmt FROM 'DESCRIBE test id'")) { 75 $db->exec('DEALLOCATE PREPARE mystmt'); 107 if ($db->exec("PREPARE mystmt FROM 'SHOW ENGINES'")) { 109 $db->exec('DEALLOCATE PREPARE mystmt'); 140 if ($db->exec("PREPARE mystmt FROM 'EXPLAIN SELECT id FROM test'")) { 142 $db->exec('DEALLOCATE PREPARE mystmt');
|
H A D | pdo_mysql_stmt_fetch_serialize.phpt | 80 $db->exec('DROP TABLE IF EXISTS test'); 81 $db->exec(sprintf('CREATE TABLE test(id INT, myobj BLOB) ENGINE=%s', 120 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_stmt_fetch_serialize_simple.phpt | 44 $db->exec('DROP TABLE IF EXISTS test'); 45 $db->exec(sprintf('CREATE TABLE test(myobj BLOB) ENGINE=%s', MySQLPDOTest::getTableEngine())); 46 $db->exec("INSERT INTO test(myobj) VALUES ('Data fetched from DB to be given to unserialize()')"); 68 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 71 $db->exec('DROP TABLE IF EXISTS test'); 79 if (!$db->exec(sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $value))) { 236 $db->exec('DROP TABLE IF EXISTS test'); 239 $db->exec('INSERT INTO test(id, label) VALUES (1, 2)'); 257 $db->exec('DROP TABLE IF EXISTS test'); 260 $db->exec('INSERT INTO test(id) VALUES (1)'); 278 $db->exec('DROP TABLE IF EXISTS test'); 281 $db->exec('INSERT INTO test(id, label1, label2) VALUES (1, 2, 3)'); 309 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_stmt_nextrowset.phpt | 47 $db->exec('DROP PROCEDURE IF EXISTS p'); 48 …$db->exec('CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; EN… 49 $db->exec('CALL p(@VERSION)'); 58 $db->exec('DROP PROCEDURE IF EXISTS p'); 59 …$db->exec('CREATE PROCEDURE p() BEGIN SELECT id FROM test ORDER BY id ASC LIMIT 3; SELECT id, labe… 102 @$db->exec('DROP PROCEDURE IF EXISTS p');
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 54 $db->exec('DROP PROCEDURE IF EXISTS p'); 55 …$db->exec('CREATE PROCEDURE p(IN cols INT) BEGIN IF cols < 2 THEN SELECT cols AS "one"; ELSE SELEC… 85 $db->exec('DROP PROCEDURE IF EXISTS p'); 86 …$db->exec('CREATE PROCEDURE p() BEGIN DECLARE cols INT; SELECT @numcols INTO cols; IF cols < 2 THE… 90 $db->exec('SET @numcols = 1'); 96 $db->exec('SET @numcols = 1'); 106 $db->exec('SET @numcols = 1'); 112 $db->exec('SET @numcols = 1');
|
H A D | pdo_mysql_subclass.phpt | 22 public function exec($statement) { 24 return parent::exec($statement); 54 $db->exec('DROP TABLE IF EXISTS test'); 55 $db->exec('CREATE TABLE test(id INT)'); 56 $db->exec('INSERT INTO test(id) VALUES (1), (2)'); 68 $db->exec('DROP TABLE IF EXISTS test'); 75 $db->exec('DROP TABLE IF EXISTS test'); 79 exec('DROP TABLE IF EXISTS test') 80 exec('CREATE TABLE test(id INT)') 81 exec('INSERT INTO test(id) VALUES (1), (2)') [all …]
|
H A D | pdo_mysql_types.phpt | 2 MySQL PDO->exec(), native types wo ZEROFILL 15 $db->exec('DROP TABLE IF EXISTS test'); 17 @$db->exec($sql); 181 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pdo_mysql_types_zerofill.phpt | 2 MySQL PDO->exec(), native types - ZEROFILL 15 $db->exec('DROP TABLE IF EXISTS test'); 17 @$db->exec($sql); 125 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pecl_bug_5200.phpt | 15 $db->exec("CREATE TABLE test (bar INT NOT NULL, phase enum('please_select', 'I', 'II', 'IIa', 'IIb'… 25 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | pecl_bug_5780.phpt | 15 $db->exec("CREATE TABLE test (login varchar(32) NOT NULL, data varchar(64) NOT NULL)"); 16 $db->exec("CREATE TABLE test2 (login varchar(32) NOT NULL, password varchar(64) NOT NULL)"); 17 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')"); 18 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')"); 33 $db->exec('DROP TABLE IF EXISTS test'); 34 $db->exec('DROP TABLE IF EXISTS test2');
|
H A D | pecl_bug_5802.phpt | 15 $db->exec('create table test ( bar char(3) NULL )'); 41 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | table.inc | 6 // $db->exec('DROP TABLE IF EXISTS test'); 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 19 $db->exec("DROP TABLE test_one_blob"); 56 $db->exec("DROP TABLE test_one_blob");
|
H A D | bug46274_2.phpt | 19 $db->exec("DROP TABLE test_one_blob"); 60 $db->exec("DROP TABLE test_one_blob");
|
H A D | bug54379.phpt | 18 $db->exec("DROP TABLE test"); 21 $db->exec("CREATE TABLE test (col1 NVARCHAR2(20))"); 22 $db->exec("INSERT INTO test VALUES('12345678901234567890')"); 23 $db->exec("INSERT INTO test VALUES('あいうえおかきくけこさしすせそたちつてと')"); 27 $db->exec("DROP TABLE test");
|
H A D | bug60994.phpt | 20 @$dbh->exec('DROP TABLE pdo_oci_bug60994'); 21 $dbh->exec('CREATE TABLE pdo_oci_bug60994 (id NUMBER, data CLOB)');
|
H A D | pdo_oci_attr_autocommit_1.phpt | 17 $dbh->exec("drop table pdo_ac_tab"); 40 $dbh->exec("create table pdo_ac_tab (col1 varchar2(20))"); 41 $dbh->exec("insert into pdo_ac_tab (col1) values ('some data')"); 52 $dbh->exec("drop table pdo_ac_tab");
|
H A D | pdo_oci_attr_autocommit_2.phpt | 16 $dbh->exec("drop table pdo_ac_tab"); 19 $dbh->exec("create table pdo_ac_tab (col1 varchar2(25))"); 25 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 1')"); 26 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 2')"); 39 $dbh->exec("insert into pdo_ac_tab (col1) values ('not committed #1')"); 51 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 3')"); 66 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 4')"); 84 $dbh->exec("rollback"); 85 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 5')"); 86 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 6')"); [all …]
|
H A D | pdo_oci_attr_autocommit_3.phpt | 19 $dbh->exec("drop table pdo_ac_tab"); 28 $dbh->exec("create table pdo_ac_tab (col1 varchar2(20))"); 30 $dbh->exec("insert into pdo_ac_tab (col1) values ('some data')"); 42 $dbh2->exec("drop table pdo_ac_tab");
|
H A D | pdo_oci_fread_1.phpt | 31 $dbh->exec($stmt); 54 $dbh->exec($stmt);
|
H A D | pdo_oci_quote1.phpt | 15 @$db->exec("drop table poq_tab"); 30 $db->exec("delete from poq_tab"); 39 @$db->exec("drop table poq_tab");
|