Home
last modified time | relevance | path

Searched refs:UPDATE (Results 1 – 25 of 69) sorted by relevance

123

/PHP-8.2/ext/sqlite3/tests/
H A Dsqlite3_18_changes.phpt18 echo "UPDATE query\n";
19 var_dump($db->exec("UPDATE test SET id = 'c'"));
34 UPDATE query
H A Dsqlite3_04_update.phpt2 SQLite3::query UPDATE tests
27 var_dump($db->exec("UPDATE test SET id = 'c' WHERE id = 'a'"));
/PHP-8.2/ext/oci8/tests/
H A Dbind_empty.phpt22 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name");
30 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name");
44 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name WHERE NAME = 'abc'");
57 $stmt = oci_parse($c, "UPDATE bind_empty_tab SET name=:name WHERE NAME = 'def'");
H A Dstatement_type.phpt14 "UPDATE table SET id = 1",
38 string(6) "UPDATE"
H A Dlob_016.phpt27 $select = "SELECT * FROM lob_test FOR UPDATE";
40 $select = "SELECT * FROM lob_test FOR UPDATE";
H A Dlob_027.phpt35 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
44 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
59 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
H A Dlob_017.phpt29 $select = "SELECT * FROM lob_test FOR UPDATE";
42 $select = "SELECT * FROM lob_test FOR UPDATE";
H A Dlob_004.phpt37 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
48 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
H A Dlob_026.phpt37 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
47 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
H A Dlob_011.phpt51 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
62 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
/PHP-8.2/ext/pgsql/tests/
H A D14pg_update.phpt27 UPDATE "php_pgsql_test" SET "num"=1234,"str"=E'ABC',"bin"=E'XYZ' WHERE "num"=1234;
28 UPDATE "php_pgsql_test" SET "num='1234',"str='ABC',"bin='XYZ' WHERE "num='1234';
H A D14pg_update_9.phpt29 UPDATE "php_pgsql_test" SET "num"=1234,"str"=E'ABC',"bin"=E'\\x58595a' WHERE "num"=1234;
30 UPDATE "php_pgsql_test" SET "num"='1234',"str"='ABC',"bin"='XYZ' WHERE "num"='1234';
H A Dpg_update_001.phpt40 string(38) "UPDATE "foo" SET "id"=10 WHERE "id"=1;"
41 string(51) "UPDATE "phptests"."foo" SET "id"=100 WHERE "id2"=2;"
/PHP-8.2/ext/pdo_firebird/tests/
H A Dexecute.phpt23 $s = $dbh->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE");
39 var_dump($dbh->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c"));
/PHP-8.2/ext/pdo_mysql/tests/
H A Dbug_pecl_12925.phpt22 $stmt = $db->prepare("UPDATE test SET id = 'b'");
24 $stmt = $db->prepare("UPDATE test SET id = 'c'");
H A Dbug_38546.phpt58 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
84 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
111 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
138 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
165 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
H A Dbug79375.phpt32 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
45 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
60 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
H A Dbug77289.phpt20 $pdo->exec("UPDATE bug77289 SET x = x");
/PHP-8.2/ext/mysqli/tests/
H A D043.phpt2 mysqli_stmt_bind_param (UPDATE)
24 $stmt = mysqli_prepare($link, "UPDATE test_update SET a=?,b=? WHERE b=?");
H A Dbug79375.phpt26 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
40 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
54 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
66 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
81 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
H A Dmysqli_fetch_assoc_zerofill.phpt23 if (!mysqli_query($link, sprintf('UPDATE test SET zero = %s', $insert))) {
24 printf("[%03d] UPDATE failed, [%d] %s\n",
H A Dmysqli_affected_rows_oo.phpt45 … if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4"))
82 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
88 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
95 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 100")) {
H A Dmysqli_affected_rows.phpt38 …if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id =…
75 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2"))
93 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2")) {
100 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 100")) {
H A Dmysqli_stmt_bind_result_zerofill.phpt23 if (!mysqli_query($link, sprintf('UPDATE test SET zero = %s', $insert))) {
24 printf("[%03d] UPDATE failed, [%d] %s\n",
/PHP-8.2/ext/pdo_sqlite/tests/
H A Dbug33841.phpt17 $stmt = $db->prepare("UPDATE test SET text = :text ");

Completed in 20 milliseconds

123