SQL Formatter

Online SQL Formatter Example

Below is an example of the original SQL Formatter and the result.

 /* CREATE TABLE */
CREATE TABLE IF NOT EXISTS TABLE_NAME(
album VARCHAR( 100 ),
year DECIMAL( 10 , 2 ),
US_peak_chart_post VARCHAR( 100 )
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'The White Stripes', 1999,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'De Stijl', 2000,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'White Blood Cells', 20.01,' 61'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Elephant', 2003,' 6'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Get Behind Me Satan', 2005,' 3'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Icky Thump', 2007,' 2'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Under Great White Northern Lights', 2010,' 11'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Live in Mississippi', 2011,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Live at the Gold Dollar', 2012,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Nine Miles from the White City', 2013,' -'
);

And an example of how the online SQL Formatter works.

 /* CREATE TABLE */
CREATE TABLE IF NOT EXISTS TABLE_NAME(
album VARCHAR( 100 ),
year DECIMAL( 10 , 2 ),
US_peak_chart_post VARCHAR( 100 )
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'The White Stripes', 1999,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'De Stijl', 2000,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'White Blood Cells', 20.01,' 61'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Elephant', 2003,' 6'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Get Behind Me Satan', 2005,' 3'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Icky Thump', 2007,' 2'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Under Great White Northern Lights', 2010,' 11'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Live in Mississippi', 2011,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Live at the Gold Dollar', 2012,' -'
);

/* INSERT QUERY */
INSERT INTO TABLE_NAME( album,year,US_peak_chart_post )
VALUES
(
    'Nine Miles from the White City', 2013,' -'
);

How to use Yttags's SQL Formatter?

• Step 1: Select the Tool

• Step 2: paste your SQL text into the textbox And Press The Format SQL Button And Check Your SQL Formatter Result