= 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

Usage: 
    '); ?>
Original Formatted And Highlighted

Formatting Only

Usage: 
    '); ?>
Original Formatted

Syntax Highlighting Only

Usage: 
    '); ?>
Original Highlighted

Compress Query

Usage: 
    '); ?>
Original Compressed

Splitting SQL Strings Into Individual Queries

Usage: 
    '); ?>
Original Split
"; foreach ($queries as $query) { echo "
  • " . SqlFormatter::highlight($query) . "
    • "; } echo ""; ?>

    Removing Comments

    Usage: 
        '); ?>
    Original Comments Removed