DmitriyShaydurov/insert.sql

Forked from bennadel/insert.sql

Created June 23, 2020 12:19

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/DmitriyShaydurov/443465b27eafc7e6d73e617e6efb24c3.js"></script>
Save DmitriyShaydurov/443465b27eafc7e6d73e617e6efb24c3 to your computer and use it in GitHub Desktop.

Download ZIP

Using The INSERT INTO ... SET Syntax In MySQL

Raw

+-- Create a new friend record.
+INSERT INTO
+	friend
+SET
+	name = 'Kim',
+	isBFF = true,
+	updatedAt = UTC_TIMESTAMP()
+;
+-- Return the newly-generated primary-key.
+SELECT
+	( @@Identity ) AS id
+;

Author

DmitriyShaydurov commented Jun 23, 2020 •

edited

Loading

Helps to resolve Atom PHP syntax highlighting issue when writing SQL inside quotes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment