Extended sql inserts Mode

For bug reports and fixes, installation issues, and new ideas for technical features.

Moderator: SEOW Developers

Post Reply
22GCT_Gross
Posts: 302
Joined: Fri 13 Apr 2007 1:13 pm
Location: Italy

Extended sql inserts Mode

Post 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?
22GCT_Gross
IV/JG7_4Shades
Posts: 2203
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post 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
IV/JG7_4Shades
SEOW Developer

Image
Post Reply