Home
last modified time | relevance | path

Searched refs:INSERT (Results 51 – 75 of 433) sorted by relevance

12345678910>>...18

/PHP-5.5/ext/pdo_firebird/tests/
H A Dbug_64037.phpt16 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (1, 'test', -1.0)");
17 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (2, 'test', -0.99)");
18 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (3, 'test', -1.01)");
H A DrowCount.phpt15 $dbh->exec("INSERT INTO testz VALUES ('A')");
16 $dbh->exec("INSERT INTO testz VALUES ('A')");
17 $dbh->exec("INSERT INTO testz VALUES ('B')");
/PHP-5.5/ext/oci8/tests/
H A Dbug42496_1.phpt19 "INSERT INTO bug42496_1_tab VALUES('test1', 'test1')",
20 "INSERT INTO bug42496_1_tab VALUES('test2', 'test2')",
21 "INSERT INTO bug42496_1_tab VALUES('test3', 'test3')"
H A Dbind_misccoltypes.phpt59 $insert_sql = "INSERT INTO bind_misccoltypes_tab ( id, "
189 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t92) VALUES (52, :n1)");
199 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t92) VALUES (53, :n1)");
209 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (54, :n1)");
218 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (55, :n1)");
229 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (56, :n1)");
237 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, varchar2_t10) VALUES (58, :c2)");
246 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, char_t10) VALUES (59, :c2)");
255 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, date_t) VALUES (60, to_date(:c2, 'YYYY-M…
/PHP-5.5/ext/pdo/tests/
H A Dpdo_007.phpt18 $db->exec("INSERT INTO test VALUES('A', 'A')");
19 $db->exec("INSERT INTO test VALUES('B', 'A')");
20 $db->exec("INSERT INTO test VALUES('C', 'C')");
H A Dpdo_020.phpt18 $db->exec("INSERT INTO test VALUES(1, 'A', 'A')");
19 $db->exec("INSERT INTO test VALUES(2, 'B', 'B')");
20 $db->exec("INSERT INTO test VALUES(3, 'C', 'C')");
H A Dpdo_032.phpt18 $db->exec("INSERT INTO test VALUES(1, 'A')");
19 $db->exec("INSERT INTO test VALUES(2, 'B')");
20 $db->exec("INSERT INTO test VALUES(3, 'C')");
H A Dpdo_027.phpt18 $db->exec("INSERT INTO test (id,name) VALUES(1,'test1')");
19 $db->exec("INSERT INTO test (id,name) VALUES(2,'test2')");
/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_affected_rows_oo.phpt31 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')"))
37 // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented
38 $mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')");
42 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4"))
48 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
54 if (!$mysqli->query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
61 if (!$mysqli->query("INSERT INTO test(id, label) SELECT id + 10, label FROM test"))
H A D004.phpt23 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890', 'this is a test0')"))
26 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567891', 'this is a test1')"))
29 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567892', 'this is a test2')"))
32 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567893', 'this is a test3')"))
H A Dmysqli_affected_rows.phpt39 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')"))
45 // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented
46 mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')");
50 …if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id =…
56 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
62 if (!mysqli_query($link, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
69 if (!mysqli_query($link, "INSERT INTO test(id, label) SELECT id + 10, label FROM test"))
H A Dmysqli_options_init_command.phpt22 !mysqli_query($link, "INSERT INTO test(id) VALUES (1)"))
37 if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(id) VALUES (2)"))
56 …if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(i_do_no_exist) VALUES (2…
62 …if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(i_do_no_exist) VALUES (2…
/PHP-5.5/ext/interbase/tests/
H A Dibase_affected_rows_001.phpt12 ibase_query($x, 'INSERT INTO test1 VALUES (1, 100)');
13 ibase_query($x, 'INSERT INTO test1 VALUES (10000, 100)');
/PHP-5.5/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_transaction.phpt16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
17 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
H A Dpdo_sqlite_lastinsertid.phpt10 $db->query('INSERT INTO foo VALUES (NULL, "PHP")');
11 $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
H A Dpdo_sqlite_createaggregate.phpt12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
H A Dpdo_sqlite_createfunction.phpt12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
/PHP-5.5/ext/odbc/tests/
H A Dodbc_exec_002.phpt16 odbc_exec($conn, 'INSERT INTO FOO VALUES (1)');
17 odbc_exec($conn, 'INSERT INTO FOO VALUES (2)');
/PHP-5.5/ext/sqlite3/tests/
H A Dbug45798.phpt12 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'a')");
13 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'b')");
H A Dsqlite3result_fetcharray_with_two_params_fails.phpt12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");
13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
H A Dsqlite3result_reset_with_params_fails.phpt12 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");
13 $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");
/PHP-5.5/ext/pdo_pgsql/tests/
H A Dbug43925.phpt26 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (1, 1, 1, 6);');
27 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (2, 1, 2, 3);');
28 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
/PHP-5.5/ext/pdo_mysql/tests/
H A Dpecl_bug_5780.phpt17 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')");
18 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')");
20 $logstmt = $db->prepare('INSERT INTO test (login, data) VALUES (:var1, :var2)');
H A Dpdo_mysql_prepare_native.phpt127 prepex(10, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
129 prepex(11, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
186 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')");
187 $db->exec("INSERT INTO test(id, label) VALUES (2, 'row2')");
204 prepex(35, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
209 prepex(38, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
211 prepex(39, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
234 prepex(45, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
273 prepex(54, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
275 prepex(55, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
[all …]
/PHP-5.5/ext/mysql/tests/
H A Dmysql_affected_rows.phpt39 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link))
45 // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented
46 @mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link);
50 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4", $lin…
56 if (!mysql_query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')", $link))
62 if (!mysql_query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')", $link)) {
69 if (!mysql_query("INSERT INTO test(id, label) SELECT id + 10, label FROM test", $link))

Completed in 29 milliseconds

12345678910>>...18