Location: PHPKode > scripts > PHP SQL Parser > PHP-SQL-Parser/testsuite/tests/parser/update.php
require_once(dirname(__FILE__) . '/../../../php-sql-parser.php');
require_once(dirname(__FILE__) . '/../../test-more.php');

$parser = new PHPSQLParser();

$sql = "UPDATE table1 SET field1='foo' WHERE field2='bar' AND id=(SELECT id FROM test1 t where t.field1=(SELECT id from test2 t2 where t2.field = 'foo'))";
$p = $parser->parsed;
$expected = getExpectedValue(dirname(__FILE__), 'update1.serialized');
eq_array($p, $expected, 'update with a sub-select');

$sql = "update SETTINGS_GLOBAL set stg_value='' where stg_name='force_ssl'";
$p = $parser->parsed;
$expected = getExpectedValue(dirname(__FILE__), 'update2.serialized');
eq_array($p, $expected, 'simple update with strings');
Return current item: PHP SQL Parser