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

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.

My ignorance - what is "full insert statements" ??

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

"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)

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).

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

@vygi

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

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

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

I found it, too

@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