complete insert statement

[mico]

can SQLyog export data as batch scripts but in complete insert statement?

e.g:

insert into `contact`.`t_company` (COMP_ID, COMP_NAME) values ('0012', 'kontak')

instead of:

insert into `contact`.`t_company` values ('0012', 'kontak')

[CalEvans]

mysqldump will do this.

=C=

[mico]

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

or there is a feature like that in sqlyog?

thanks,

[Ritesh]

Cal means the shell tool that comes with MySQL. SQLyog does not add the column name in the Insert Statement to make the resulting file small in size 😀

HTH

[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,

[Author]

Posts