Can the SQL \"truncate table\" comm开发者_StackOverflowand be used within a transaction?I am creating an app and my table has a ton of records.I want to delete all the records, but if the app fails I
I have a table in one database, call this db x. I have another database, call it y. I want to copy data from x.some_table to y.some_table. I don\'t want to do an exact copy of the table, because some