I want to export data from a sql table, but I dont want the primary key to be exported.
The reason is that I have data on my localhost that needs to be inserted in a remote database (remote and local db have the same structure). But on the remote db, th开发者_C百科e table already has data, and they will be primary key conflicts if I try to add the data from my localhost.
This question has somehow been treated here before: table-without-dumping-the-primary-key.
I used this method in the past, but it's annoying to have to create a new table to make the transfer...
It surprises me that I can't export data from a table while omitting a column, in this case, the primary key column. Been looking the mysql documentation but it wasn't helpful...
Any idea?
Can you create a VIEW without the primary key, and then export VIEW DATA?
精彩评论