Is there a way to backup data using mysqldump --no-create-info ... where the inserts in the backup file will look like this:
insert into t1(col1, col2)values(val1,val2);
insert into t1 values(val1,val2);
The problem with the second way is that when the table structure changes, the insert will not work. With the first way, the table structure, e.g, one more column is added, will not affect the insert statement.
I have to use the mysqldump. Any suggestions please?