Home
last modified time | relevance | path

Searched refs:INSERT (Results 1 – 25 of 509) sorted by relevance

12345678910>>...21

/PHP-8.3/ext/pdo_dblib/tests/
H A Dbug_38955.phpt16 $db->query("INSERT INTO php_test(val) values(1)");
17 $db->query("INSERT INTO php_test(val) values(2)");
18 $db->query("INSERT INTO php_test(val) values(3)");
19 $db->query("INSERT INTO php_test(val) values(4)");
24 $db->query("INSERT INTO php_test(val) values(5)");
25 $db->query("INSERT INTO php_test(val) values(6)");
26 $db->query("INSERT INTO php_test(val) values(7)");
27 $db->query("INSERT INTO php_test(val) values(8)");
/PHP-8.3/ext/sqlite3/tests/
H A Dsqlite3_25_create_aggregate.phpt27 echo "INSERT into table\n";
28 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
29 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
30 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
31 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
32 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
45 INSERT into table
H A Dsqlite3_03_insert.phpt2 SQLite3::query INSERT tests
14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
33 INSERT into table
H A Dsqlite3_trampoline_create_aggregate.phpt32 echo "INSERT into table\n";
33 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
34 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
35 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
36 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
37 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
50 INSERT into table
H A Dsqlite3_24_last_insert_rowid.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
27 INSERT into table
H A Dsqlite3_13_skip_all_cleanup.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
29 INSERT into table
H A Dsqlite3_14_querysingle.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
27 INSERT into table
H A Dsqlite3_18_changes.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
31 INSERT into table
H A Dsqlite3_23_escape_string.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", '" . SQLite3::escapeString…
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
33 INSERT into table
H A Dsqlite3_07_prepared_stmt.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
37 INSERT into table
H A Dsqlite3_08_udf.phpt19 echo "INSERT into table\n";
20 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
41 INSERT into table
H A Dsqlite3_06_prepared_stmt.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
38 INSERT into table
H A Dsqlite3_11_numrows.phpt23 echo "INSERT into table\n";
24 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
25 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
40 INSERT into table
H A Dsqlite3_19_columninfo.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
35 INSERT into table
H A Dsqlite3_bound_value_at_name.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
37 INSERT into table
H A Dsqlite3_26_reset_prepared_stmt.phpt14 echo "INSERT into table\n";
15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
41 INSERT into table
/PHP-8.3/ext/pdo_firebird/tests/
H A Dgh13119.phpt17 $dbh->exec('INSERT INTO gh13119 VALUES (0.1, 0.1)');
18 $dbh->exec('INSERT INTO gh13119 VALUES (0.0000000000000001, 0.0000000000000001)');
19 $dbh->exec('INSERT INTO gh13119 VALUES (12.000000, 12.00000000000000)');
20 $dbh->exec('INSERT INTO gh13119 VALUES (12.000001, 12.00000000000001)');
21 $dbh->exec('INSERT INTO gh13119 VALUES (12.345678, 12.34567890123456)');
22 $dbh->exec('INSERT INTO gh13119 VALUES (0.0000000000000000012345678, 0.0000000000000000012345678901…
/PHP-8.3/ext/pdo_mysql/tests/
H A Dbug_44454.phpt24 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
30 printf("... INSERT should fail...\n");
31 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
40 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
50 printf("... INSERT should fail...\n");
51 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
81 ... INSERT should fail...
89 ... INSERT should fail...
99 ... INSERT should fail...
107 ... INSERT should fail...
H A Dlast_insert_id.phpt19 print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));
21 print_r($db->query("INSERT INTO test (num) VALUES (451)"));
32 [queryString] => INSERT INTO test (id, num) VALUES (23, 42)
36 [queryString] => INSERT INTO test (num) VALUES (451)
H A Dbug78152.phpt17 var_dump($db->exec("INSERT INTO test(id, label) VALUES (41, 'x'); INSERT INTO test_bad(id, label) V…
20 …var_dump($db->exec("INSERT INTO test(id, label) VALUES (42, 'x'); INSERT INTO test_bad(id, label) …
/PHP-8.3/ext/oci8/tests/
H A Dbind_sqltchr_1.phpt43 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, varchar2_t10) VALUES (241, :c2)");
52 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (242, :n1)");
61 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (243, :n1)");
70 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (244, :n1)");
79 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (245, :n1)");
88 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (246, :n1)");
97 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t) VALUES (247, :n1)");
106 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t92) VALUES (248, :n1)");
115 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t92) VALUES (249, :n1)");
124 $s = oci_parse($c, "INSERT INTO bind_sqltchr_tab (id, number_t92) VALUES (250, :n1)");
H A Dbind_sqltnum.phpt46 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (100, :c2)");
82 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, varchar2_t10) VALUES (41, :c2)");
88 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (42, :n1)");
97 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (43, :n1)");
106 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (44, :n1)");
115 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (45, :n1)");
124 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (46, :n1)");
133 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t) VALUES (47, :n1)");
142 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t92) VALUES (48, :n1)");
151 $s = oci_parse($c, "INSERT INTO bind_sqltnum_tab (id, number_t92) VALUES (49, :n1)");
[all …]
H A Dbind_number.phpt45 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, number_t6) VALUES (1, :n1)");
54 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, float_t) VALUES (66, :f1)");
63 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_float_t) VALUES (67, :f1)");
72 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_double_t) VALUES (69, :f1)");
81 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, decimal_t) VALUES (71, :f1)");
90 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, decimal_t) VALUES (72, :f1)");
99 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, binary_double_t) VALUES (73, :f1)");
108 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, integer_t) VALUES (75, :f1)");
117 $s = oci_parse($c, "INSERT INTO bind_number_tab (id, integer_t) VALUES (76, :f1)");
/PHP-8.3/ext/pdo/tests/
H A Dpdo_009.phpt19 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')');
20 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')');
21 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')');
23 $db->exec('INSERT INTO test VALUES(1, 0, \'A\')');
24 $db->exec('INSERT INTO test VALUES(2, 1, \'B\')');
25 $db->exec('INSERT INTO test VALUES(3, 2, \'C\')');
26 $db->exec('INSERT INTO test VALUES(4, 3, \'D\')');
H A Dpdo_010.phpt19 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')');
20 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')');
21 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')');
23 $db->exec('INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')');
24 $db->exec('INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')');
25 $db->exec('INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')');
26 $db->exec('INSERT INTO test VALUES(4, 3, \'D\', \'Group2\')');

Completed in 37 milliseconds

12345678910>>...21