/var/www/vhosts/ihelp.ro/httpdocs/vendor/jdorn/sql-formatter/examples
Edit: /var/www/vhosts/ihelp.ro/httpdocs/vendor/jdorn/sql-formatter/examples/examples.php (6525B)
SqlFormatter Examples
=
DATE_FORMAT((DATE_SUB(NOW(),INTERVAL 1 DAY)),'%Y-%c-%d') AND t_create
< DATE_FORMAT(NOW(), '%Y-%c-%d') ORDER BY d.id LIMIT 2,10) a,
orc_scheme_detail b WHERE a.id = b.id",
"SELECT * from Table1 LEFT
OUTER JOIN Table2 on Table1.id = Table2.id",
"SELECT * FROM MyTable WHERE id = 46",
"SELECT count(*),`Column1` as count,`Testing`, `Testing Three` FROM `Table1`
WHERE Column1 = 'testing' AND ( (`Column2` = `Column3` OR Column4 >= 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;",
);
// Example statements for splitting SQL strings into individual queries
$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;",
"
-- Drop the table first if it exists
DROP TABLE IF EXISTS MyTable;
-- Create the table
CREATE TABLE MyTable ( id int );
-- Insert values
INSERT INTO MyTable (id)
VALUES
(1),(2),(3),(4);
-- Done",
);
// Example statements for removing comments
$comment_statements = array(
"-- 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;",
);
?>
Formatting And Syntax Highlighting
| Original |
Formatted And Highlighted |
|
|
|
Formatting Only
Syntax Highlighting Only
Compress Query
Splitting SQL Strings Into Individual Queries
| Original |
Split |
|
|
";
foreach ($queries as $query) {
echo "" . SqlFormatter::highlight($query) . " ";
}
echo "";
?> |
Removing Comments
| Original |
Comments Removed |
|
|
|