=
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
SQL,
<<<'SQL'
SELECT * from Table1 LEFT
OUTER JOIN Table2 on Table1.id = Table2.id
SQL,
<<<'SQL'
SELECT * FROM MyTable WHERE id = 46'
SQL,
<<<'SQL'
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
SQL,
<<<'SQL'
select * from `Table`, (SELECT group_concat(column1) as col FROM Table2 GROUP BY category)
Table2, Table3 where Table2.col = (Table3.col2 - `Table`.id)
SQL,
<<<'SQL'
insert ignore into Table3 (column1, column2) VALUES ('test1','test2'), ('test3','test4');
SQL,
<<<'SQL'
UPDATE MyTable SET name='sql', category='databases' WHERE id > '65'
SQL,
<<<'SQL'
delete from MyTable WHERE name LIKE "test%"'
SQL,
<<<'SQL'
SELECT * FROM UnmatchedParens WHERE ( A = B)) AND (((Test=1)
SQL,
<<<'SQL'
-- 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;
SQL,
];
// Example statements for splitting SQL strings into individual queries
$splitStatements = [
<<<'SQL'
DROP TABLE IF EXISTS MyTable;
CREATE TABLE MyTable ( id int );
INSERT INTO MyTable (id)
VALUES
(1),(2),(3),(4);
SELECT * FROM MyTable;
SQL,
<<<'SQL'
SELECT ";"; SELECT ";\\"; a;";
SELECT ";
abc";
SELECT a,b #comment;
FROM test;
SQL,
<<<'SQL'
-- 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
SQL,
];
// Example statements for removing comments
$commentStatements = [
<<<'SQL'
-- 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;
SQL,
];
?>
SqlFormatter Examples
Formatting And Syntax Highlighting
Usage:
format($sql);' . "\n" . '?>'
); ?>
| Original |
Formatted And Highlighted |
|
|
format($sql); ?> |
Formatting Only
Usage:
format($sql);' .
"\n" . '?>'); ?>
| Original |
Formatted |
|
|
format($sql)); ?> |
Syntax Highlighting Only
Usage:
highlight($sql);' . "\n" . '?>'
); ?>
| Original |
Highlighted |
|
|
highlight($sql); ?> |
Compress Query
Usage:
compress($sql);' . "\n" . '?>'
); ?>
| Original |
Compressed |
|
|
compress($sql); ?> |