Home
last modified time | relevance | path

Searched refs:exec (Results 151 – 175 of 321) sorted by path

12345678910>>...13

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_closecursor_empty.phpt61 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_stmt_errorcode.phpt15 $db->exec('DROP TABLE IF EXISTS ihopeitdoesnotexist');
H A Dpdo_mysql_stmt_errorinfo.phpt29 $db->exec('DROP TABLE test');
51 $db->exec('DROP TABLE test');
H A Dpdo_mysql_stmt_fetch_non_select.phpt73 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 Dpdo_mysql_stmt_fetch_serialize.phpt80 $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 Dpdo_mysql_stmt_fetch_serialize_simple.phpt44 $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 Dpdo_mysql_stmt_getcolumnmeta.phpt71 $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 Dpdo_mysql_stmt_nextrowset.phpt47 $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 Dpdo_mysql_stmt_variable_columncount.phpt54 $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 Dpdo_mysql_subclass.phpt22 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 Dpdo_mysql_types.phpt2 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 Dpdo_mysql_types_zerofill.phpt2 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 Dpecl_bug_5200.phpt15 $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 Dpecl_bug_5780.phpt15 $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 Dpecl_bug_5802.phpt15 $db->exec('create table test ( bar char(3) NULL )');
41 $db->exec('DROP TABLE IF EXISTS test');
H A Dtable.inc6 // $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 Dbug46274.phpt19 $db->exec("DROP TABLE test_one_blob");
56 $db->exec("DROP TABLE test_one_blob");
H A Dbug46274_2.phpt19 $db->exec("DROP TABLE test_one_blob");
60 $db->exec("DROP TABLE test_one_blob");
H A Dbug54379.phpt18 $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 Dbug60994.phpt20 @$dbh->exec('DROP TABLE pdo_oci_bug60994');
21 $dbh->exec('CREATE TABLE pdo_oci_bug60994 (id NUMBER, data CLOB)');
H A Dpdo_oci_attr_autocommit_1.phpt17 $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 Dpdo_oci_attr_autocommit_2.phpt16 $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 Dpdo_oci_attr_autocommit_3.phpt19 $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 Dpdo_oci_fread_1.phpt31 $dbh->exec($stmt);
54 $dbh->exec($stmt);
H A Dpdo_oci_quote1.phpt15 @$db->exec("drop table poq_tab");
30 $db->exec("delete from poq_tab");
39 @$db->exec("drop table poq_tab");

Completed in 29 milliseconds

12345678910>>...13