[mico]

thanks for your explanation,

in mysqlfront, there is a same feature like that. we can check the checkbox option when we want to make insert statement with column name. there is also same feature in phpmyadmin.

btw… sometimes we need “column name” in insert statement.

e.g:

we have table a with a data in it.

we want to change some of columns in that table, but with other program.

so, we export the data to data.sql.

change the table with “execute batch file” feature.

and, we reimport the data.sql to the table.

if the columns name/number doesn''t same it cannot run.

---

I like using sqlyog very much, hope in next release this feature has included.

🙂

best regards,

[mico]

do you mean using mysqldump shell / tool which come with mysql?

or there is a feature like that in sqlyog?

thanks,

[Author]

Posts