Lines Matching refs:FORMAT
2 Playing with SELECT FORMAT(...) AS _format - see also bugs.php.net/42378
147 test_format($link, 'FORMAT(1.01, 0)', 'DUAL', null, '1', 10);
148 test_format($link, 'FORMAT(1.23, 1)', 'DUAL', null, '1.2', 20);
149 test_format($link, 'FORMAT(1.23, 2)', 'DUAL', null, '1.23', 30);
150 test_format($link, 'FORMAT(1234.567, 3)', 'DUAL', null, '1,234.567', 40);
152 test_format($link, 'FORMAT(1234.567, 4)', 'DUAL', null, '1,234.5670', 50);
158 test_format($link, 'FORMAT(id, 0)', 'test', null, '1', 60);
159 test_format($link, 'FORMAT(id + 0.1, 1)', 'test', null, '1.1', 70);
160 test_format($link, 'FORMAT(id + 0.01, 2)', 'test', null, '1.01', 80);
166 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 100);
171 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 120);
176 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 140);
181 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 160);
186 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 180);
191 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 200);
196 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 220);
201 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 240);
250 …if (!mysqli_stmt_prepare($stmt, 'SELECT trend, targetport, FORMAT(trend, 2) FROM test WHERE curren…
289 …if (!$stmt->prepare('SELECT trend, targetport, FORMAT(trend, 2) FROM test WHERE current_targets > …
