Home
last modified time | relevance | path

Searched refs:AS (Results 26 – 50 of 249) sorted by relevance

12345678910

/PHP-8.3/ext/pdo/tests/
H A Dbug_60665.phpt22 $statement = $db->prepare("SELECT NULL AS null_value, 0 AS zero, 1 AS one $from");
/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_change_user_locks_temporary.phpt23 if ($res = mysqli_query($link2, 'SELECT COUNT(*) AS _num FROM test')) {
33 if (!$res = mysqli_query($link2, 'SELECT COUNT(*) AS _num FROM test'))
54 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test'))
68 if ($res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test')) {
74 if (!$res = mysqli_query($link, 'SELECT GET_LOCK("phptest", 2) AS _ok'))
88 if (!$res = mysqli_query($link, 'SELECT IS_FREE_LOCK("phptest") AS _ok'))
H A Dmysqli_connect_oo_defaults.phpt34 if (!$res = $mysqli->query("SELECT 'mysqli.default_socket' AS testing"))
57 if (!$res = $mysqli->query("SELECT 'mysqli.default_port' AS testing"))
75 if (!$res = $mysqli->query("SELECT 'mysqli.default_pw' AS testing"))
93 if (!$res = $mysqli->query("SELECT 'mysqli.default_user' AS testing"))
115 if (!$res = $mysqli->query("SELECT SUBSTRING_INDEX(USER(),'@',1) AS username"))
133 if (!$res = mysqli_query($link, "SELECT 'have been set' AS all_defaults"))
146 if (!$res = mysqli_query($link, "SELECT 'have been set' AS all_defaults"))
H A Dmysqli_change_user.phpt35 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var'))
45 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user'))
80 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user'))
103 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var'))
113 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user'))
123 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var'))
H A Dmysqli_change_user_oo.phpt38 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
48 if (!$res = $mysqli->query('SELECT database() AS dbname, user() AS user'))
58 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
H A Dmysqli_explain_metadata.phpt13 if (!$res = mysqli_query($link, 'EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2'))
64 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) {
99 $stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') &&
H A Dmysqli_query_unicode.phpt30 if (!$res = mysqli_query($link, "SELECT 'това ескюел, но с точка и запетая' AS правилен ; "))
36 …if (false !== ($res = mysqli_query($link, "SELECT 'това ескюел, но с точка и запетая' AS правилен …
44 $res = mysqli_query($link, 'SELECT @version AS п_версия');
59 $res = mysqli_query($link, 'SELECT функцийка(VERSION()) AS ф_версия');
H A Dmysqli_stmt_bind_result_format.phpt2 Playing with SELECT FORMAT(...) AS _format - see also bugs.php.net/42378
60 $sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by);
62 $sql = sprintf('SELECT %s AS _format FROM %s', $format, $from);
168 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 100);
173 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 120);
178 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 140);
183 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 160);
188 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 180);
193 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 200);
198 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 220);
[all …]
H A Dmysqli_change_user_old.phpt47 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var'))
57 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user'))
67 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var'))
96 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user'))
H A Dmysqli_field_count.phpt28 if (!$res = mysqli_query($link, "SELECT NULL as _null, '' AS '', 'three' AS 'drei'"))
H A Dmysqli_change_user_rollback.phpt23 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test'))
36 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test'))
49 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test'))
H A Dmysqli_query.phpt28 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; "))
34 if (!$res = mysqli_query($link, "SELECT 'a' AS ''"))
41 …if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW…
49 $res = mysqli_query($link, 'SELECT @version AS p_version');
64 $res = mysqli_query($link, 'SELECT f(VERSION()) AS f_version');
H A Dmysqli_character_set_name.phpt18 if (!$res = mysqli_query($link, 'SELECT version() AS server_version'))
29 … = mysqli_query($link, 'SELECT @@character_set_connection AS charset, @@collation_connection AS co…
H A Dmysqli_character_set_name_oo.phpt16 if (!$res = $mysqli->query('SELECT version() AS server_version'))
27 …!$res = $mysqli->query('SELECT @@character_set_connection AS charset, @@collation_connection AS co…
/PHP-8.3/ext/pdo_mysql/tests/
H A Dbug44327.phpt17 $stmt = $db->prepare("SELECT 1 AS \"one\"");
48 string(17) "SELECT 1 AS "one""
54 string(17) "SELECT 1 AS "one""
H A Dpdo_mysql_stmt_variable_columncount.phpt52 …EDURE p(IN cols INT) BEGIN IF cols < 2 THEN SELECT cols AS "one"; ELSE SELECT 1 AS "one", cols AS …
83 …IF cols < 2 THEN SET @numcols = 2; SELECT cols AS "one"; ELSE SET @numcols = 1; SELECT 1 AS "one",…
H A Dpdo_mysql_rollback.phpt21 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
26 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
32 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
56 $row = $db->query('SELECT COUNT(*) AS _num FROM test2')->fetch(PDO::FETCH_ASSOC);
/PHP-8.3/ext/oci8/tests/
H A Dbug71422.phpt22 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1');
28 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes…
36 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test…
H A Dbug74625.phpt17 "CREATE OR REPLACE PACKAGE PKG74625 AS
21 "CREATE OR REPLACE PACKAGE BODY PKG74625 AS
H A Dbug40078.phpt17 CREATE OR REPLACE PACKAGE BUG40078_PKG AS
25 CREATE OR REPLACE PACKAGE BODY BUG40078_PKG AS
/PHP-8.3/ext/pdo_sqlite/tests/
H A Dgh9032.phpt11 $db->exec('attach database \':memory:\' AS "db1"');
15 $st = $db->prepare('attach database :a AS "db2"');
/PHP-8.3/ext/sqlite3/tests/
H A Dgh9032.phpt12 $db->exec('attach database \':memory:\' AS "db1"');
16 $st = $db->prepare('attach database :a AS "db2"');
/PHP-8.3/ext/pdo_pgsql/tests/
H A Dbug69344.phpt26 $stmt = $pdo->prepare("SELECT (?)::text AS a, (?)::text AS b");
/PHP-8.3/Zend/tests/
H A Dbug68215.phpt29 foreach ($child AS $key => $fruit)
42 foreach ($arr AS $key => $fruit)
/PHP-8.3/ext/pdo_firebird/tests/
H A Dgh10908.phpt49 query_and_dump($dbh, "SELECT CAST(NUM AS NUMERIC(9, 3)) FROM gh10908"); // works fine
50 query_and_dump($dbh, "SELECT CAST(ID AS INTEGER) FROM gh10908"); // works fine
51 query_and_dump($dbh, "SELECT CAST(ID AS BIGINT) FROM gh10908"); // Used to "bus error"

Completed in 57 milliseconds

12345678910