Update Export …

[LeHHeL]

I would like to have an opportunity to export a filtered page like

SELECT image_small, image, id_product FROM secpage;

Then the result to be exportable into …

UPDATE `secpage` SET `image_small` = 'm1240769_99060101244_col40ksmassaultweaponsmain_445x319.jpg', `image` = 'm1240769_99060101244_col40ksmassaultweaponsmain_445x319.jpg', `id_product` = 241 WHERE `id_product` = 241;

This can be done in phpMyAdmin easily (also REPLACE). I think would help.

Actually could be a solution for me what I miss.

I tried to copy from a table to an another table where the structure is different. I need to get 2 columns into the new table from old table, without altering the database. So I export now as UPDATE and change the table name and import back into new table.

I cannot do the Schema Tools Database sync cause then need to be exact table structure.

[Author]

Posts