To get insert statement like INSERT INTO TBL (A, B, C) VALUES (1, 2, 3),
what command I have to use?
On Friday, August 9, 2019 at 7:24:48 AM UTC+5:30 Evgenij Ryazanov wrote:
> You don't need a COLUMNS clause. It only changes insert statements from
> INSERT INTO TBL VALUES (1, 2, 3) to INSERT
You don't need a COLUMNS clause. It only changes insert statements from
INSERT INTO TBL VALUES (1, 2, 3) to INSERT INTO TBL (A, B, C) VALUES (1, 2,
3), it can be useful if you want to load the script into some other
database that don't support insert statements without names of columns.
I only