Home
last modified time | relevance | path

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

123

/PHP-5.4/ext/interbase/tests/
H A Dibase_affected_rows_001.phpt15 ibase_query($x, 'UPDATE test1 SET i = 10000');
19 ibase_query($x, 'UPDATE test1 SET i = 10000 WHERE i = 2.0');
22 ibase_query($x, 'UPDATE test1 SET i =');
/PHP-5.4/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-5.4/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 Dstatement_type_old.phpt21 "UPDATE table SET id = 1",
46 string(6) "UPDATE"
H A Dlob_027.phpt33 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
42 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
53 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
H A Dlob_016.phpt25 $select = "SELECT * FROM lob_test FOR UPDATE";
38 $select = "SELECT * FROM lob_test FOR UPDATE";
H A Dlob_017.phpt27 $select = "SELECT * FROM lob_test FOR UPDATE";
40 $select = "SELECT * FROM lob_test FOR UPDATE";
H A Dlob_004.phpt35 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
46 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
H A Dlob_011.phpt49 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
60 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
H A Dlob_026.phpt37 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
51 $select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
H A Dlob_035.phpt49 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
74 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
/PHP-5.4/ext/pgsql/tests/
H A Dpg_update_001.phpt38 string(38) "UPDATE "foo" SET "id"=10 WHERE "id"=1;"
39 string(51) "UPDATE "phptests"."foo" SET "id"=100 WHERE "id2"=2;"
H A D14pg_update.phpt24 UPDATE "php_pgsql_test" SET "num"=1234,"str"=E'ABC',"bin"=E'XYZ' WHERE "num"=1234;
H A D14pg_update_9.phpt26 UPDATE "php_pgsql_test" SET "num"=1234,"str"=E'ABC',"bin"=E'\\x58595a' WHERE "num"=1234;
H A D98old_api.phpt25 $result = pg_exec("UPDATE ".$table_name." SET str = 'QQQ' WHERE str like 'RGD';");
/PHP-5.4/ext/pdo_firebird/tests/
H A Dexecute.phpt23 $s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE");
39 var_dump($db->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c"));
/PHP-5.4/ext/pdo_mysql/tests/
H A Dbug_pecl_12925.phpt21 $stmt = $db->prepare("UPDATE test SET id = 'b'");
23 $stmt = $db->prepare("UPDATE test SET id = 'c'");
/PHP-5.4/ext/mysqli/tests/
H A D043.phpt2 mysqli_stmt_bind_param (UPDATE)
23 $stmt = mysqli_prepare($link, "UPDATE test_update SET a=?,b=? WHERE b=?");
H A Dmysqli_affected_rows_oo.phpt42 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4"))
79 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
85 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
92 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 100")) {
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.phpt50 …if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id =…
87 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2"))
105 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2")) {
112 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-5.4/ext/mysql/tests/
H A Dmysql_affected_rows.phpt50 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4", $lin…
87 if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link))
93 if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link)) {
100 if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 100", $link)) {

Completed in 24 milliseconds

123