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 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 need a script with all my database inserts. > > Unfortunately, H2 doesn't export such scripts. And I don't think that such > script will be suitable for your use case, that was described here: > https://groups.google.com/forum/#!topic/h2-database/1j9OAZpy5NA > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/03686324-f0ed-4cbd-bb0e-a454e7bac135n%40googlegroups.com.
