Full Insert (sql Export)

[larsen]

Hello,

is there a possibility to have SQLyog create full insert statements when exporting to sql queries like phpMyAdmin does?

I have reorderd the table structure through creating a copy of the table and now want to import the data of the old table. As the order of the table has changed I would have to manually insert the field names so that the data could be imported to the right fields.

It would also be nice if I could re-arrange the fields with the “Alter Table” window.

Lars

[larsen]

Ok, I just found that I can reorder the table structure already 😀

Could you add a button to the “alter table” window, too?

Full inserts would still be nice.

[peterlaursen]

My ignorance – what is “full insert statements” ??

BTW: I DO NOT ACCEPT the use of phpmyadmin as a reference … 😛

[larsen]

peterlaursen wrote on Dec 8 2005, 10:00 AM:

My ignorance – what is “full insert statements” ??

BTW: I DO NOT ACCEPT the use of phpmyadmin as a reference …  😛

[post=”8146″]<{POST_SNAPBACK}>[/post]

“Full inserts” mean that the columns are stated in the sql string.

Here is an example of what SQLyog looks like:

INSERT INTO `tableX` VALUES (value1, 'value2', value3)

Here an example of phpM… I mean, ermm, another MySQL Frontend 😛

INSERT INTO `tableX` (`field1`, `field2`, `field3`) VALUES (value1, 'value2', value3)

[peterlaursen]

Thanks for the enlightment!

Well, yes that could be useful too.

However you could also use the DATA SYNC tool. Import the .sql to a 'dummy' database and sync the 'dummy' with the 'real' DB. It gives you more options, I think (row filtering, column filtering).

[vygi]

peterlaursen wrote on Dec 8 2005, 11:54 AM:

Thanks for the enlightment!

Well, yes that could be useful too.

However you could also use the DATA SYNC tool.  Import the .sql to a 'dummy' database and sync the 'dummy' with the 'real' DB.  It gives you more options, I think (row filtering, column filtering).

[post=”8151″]<{POST_SNAPBACK}>[/post]

I'm not really sure but I think that Data Synchronization will fail if tables have different field order.

See this thread: http://www.webyog.com/forums/index.php?showtopic=1841

[peterlaursen]

@vygi

I think you are right, and if that is the case I'm wrong! <_<

[Ritesh]

As the attached screenshot suggest, you can select Generate complete INSERT statements 😀

[peterlaursen]

looks like Ritesh found a shortcut to the BIGGRIN smiley today! 😀

[larsen]

I found it, too 😀

[peterlaursen]

@vygi, you are/were right.

Hard to remember all details as MySQL (and SQLyog too) becomes more complex!

I wrote up this FAQ: http://www.webyog.com/faq/10_84_en.html

[Author]

Posts