In TSQL I can state:
insert into myTable (ID) values (5) GO select * from myTable
In MySQL I can’t write the same query.
What is the correct way to write this query in MySQL?
Advertisement
Answer
Semicolon at the end of the statement.
INSERT INTO myTable (ID) values (5);