Page 1 of 1

Extended sql inserts Mode

Posted: Sun 01 Mar 2009 8:54 am
by 22GCT_Gross
4S,
your SEDB32 readme advertised on Extended sql inserts Mode.
the new extendedins database versions are liter than standard ones, so I wonder if I could manage it by sqlyog Gui.
I found only this feature on sqlyog about SQL dump options:

Code: Select all

Create Bulk Insert statement(s): To generate script to insert all rows in one INSERT statement, resulting smaller script size and faster execution. Otherwise one INSERT statement will be generated for insertion of each row.
Is Bulk Insert Statements matching the Extended sql inserts Mode?

Posted: Sun 01 Mar 2009 9:44 am
by IV/JG7_4Shades
Hi Gross,

Yes, it seems to be a matter of terminology.

Navicat says "extended inserts"
Yog says "bulk inserts"

Anyway the SEDB32 README explains that each MySQL DB comes in standard format (one INSERT per row) and in extended format (many rows per INSERT).

Use whichever you like. :D

Cheers,
4Shades