Omitting "INTO" in "INSERT INTO" Statement

Asked Jul 12 '17 at 20:57

Active Jul 12 '17 at 20:57

Viewed 48 times

You can apparently interchangeably include or omit INTO in INSERT statements at least both in MySQL and SQL Server:

-- works:
INSERT INTO Table (Column) VALUES (1);
-- also works:
INSERT Table (Column) VALUES (1);

Why is this and which approach should be taken?

asked Jul 12 '17 at 20:57

reformed

Not really sure why this is except for ease of writing if someone for gets a command. I would always adhere to best practices and write it all out correctly. – Wes Palmer Jul 12 '17 at 21:00
1

@reformed same as `DELETE` and `DELETE FROM` – Lukasz Szozda Jul 12 '17 at 21:32

0 Answers0