Using below query, you can take backup of table in SQL Server:
SELECT * INTO [NewTableName] FROM [BackupTable]
Using below query, you can take backup of table in MySql:
SELECT * INTO [NewTableName] FROM [BackupTable]
Using below query, you can take backup of table in MySql:
CREATE TABLE [NewTableName] SELECT * FROM [BackupTable]
Great work.. Thanks kapil..
ReplyDelete