How to import and export record from table to another MySQL without import ID

How to import and export record from table to another MySQL without import ID ?

Come importare ed esportare record da una tabella mysql a un’altra senza importare l’ID?

INSERT INTO databasename.TargetTable (column_list) SELECT column_list FROM databasename.SourceTable

Example

INSERT INTO newproject.content (desc,author,`fulltext`) SELECT desc,author,`fulltext` FROM oldproject.content

Note

If you have fulltext field in your column_list, you have to use the quote (`fulltext`) otherwise you meet a mysql error.
Well done!

Best Regards,
ITquadro – specialized Blog