Skip to content

Instantly share code, notes, and snippets.

@dungsaga
Created March 9, 2022 07:24
Show Gist options
  • Save dungsaga/b0c3a65bae36e022a9432e47f3c76bbf to your computer and use it in GitHub Desktop.
Save dungsaga/b0c3a65bae36e022a9432e47f3c76bbf to your computer and use it in GitHub Desktop.
vertical horizon code style

It's quite common to write SQL queries in a vertical horizon code style. For example:

INSERT INTO table (
    column1,
    column2,
    column3,
    column4,
    column5,
    column6,
    column7,
    column8
) VALUES (
    'value A',
    'value B',
    'value C',
    'value D',
    'value E',
    'value F',
    'value G',
    'value H'
);

It's better to put column names and values next to each other:

INSERT INTO table
SELECT
    'value A' AS column1,
    'value B' AS column2,
    'value C' AS column3,
    'value D' AS column4,
    'value E' AS column5,
    'value F' AS column6,
    'value G' AS column7,
    'value H' AS column8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment