= NOW()) )
GROUP BY Column1 ORDER BY Column3 DESC LIMIT 5,10",
"select * from `Table`, (SELECT group_concat(column1) as col FROM Table2 GROUP BY category)
Table2, Table3 where Table2.col = (Table3.col2 - `Table`.id)",
"insert ignore into Table3 (column1, column2) VALUES ('test1','test2'), ('test3','test4');",
"UPDATE MyTable SET name='sql', category='databases' WHERE id > '65'",
"delete from MyTable WHERE name LIKE \"test%\"",
"SELECT * FROM UnmatchedParens WHERE ( A = B)) AND (((Test=1)",
"-- This is a comment
SELECT
/* This is another comment
On more than one line */
Id #This is one final comment
as temp, DateCreated as Created FROM MyTable;",
);
echo "Formatting
";
foreach($statements as $sql) {
echo "
";
echo SqlFormatter::format($sql);
}
echo "Syntax Highlighting Only
";
foreach($statements as $sql) {
echo "
";
echo SqlFormatter::highlight($sql);
}
$split_statements = array(
'DROP TABLE IF EXISTS MyTable;
CREATE TABLE MyTable ( id int );
INSERT INTO MyTable (id)
VALUES
(1),(2),(3),(4);
SELECT * FROM MyTable;',
'SELECT ";"; SELECT ";\"; a;";
SELECT ";
abc";
SELECT a,b #comment;
FROM test;'
);
echo "Splitting Queries
";
foreach($split_statements as $sql) {
echo "
";
$queries = SqlFormatter::splitQuery($sql);
echo "";
foreach($queries as $query) {
echo "- ".SqlFormatter::highlight($query)."
";
}
echo "
";
}
?>