MySQL Table Backup

• There is no pre-built table, direct backup, but MySQL does not support select into to back up the table, but you can use the following table statement to back up:

CREATE TABLE User_backup (SELECT * from user), select * from User_backup;

[Sql]create Table User_backup (SELECT * from user); Affected Rows:22time:0.129s[sql]select * from User_backup; Affected rows:0time:0.001s

• Pre-existing tables, copy data from the table in the data source to insert into the target table

mysql> INSERT INTO User_temp (SELECT * from user); Query OK, Rows affectedrecords:22 duplicates:0 warnings:0mysql> select * from User_temp;

• Clears table data, preserves table structure

mysql> truncate TABLE user_temp; Query OK, 0 rows affectedmysql> select * from User_temp; Empty Set

• In addition, SQL Server supports select INTO, but does not support the SELECT INTO

Use Hunlian;select * to Member_backup in Hunlian-test.mdb from Hunlian.dbo.member;

[Sql]use hunlianaffected Rows:0time:0.007s[sql]select * into Member_backup in Hunlian-test.mdb from hunlian.dbo.member[ ERR] 42000-There is a syntax error near the [SQL Server] keyword ' in '. Affected rows:0

Use hunlian;/* because the two tables contain the same ID field, the direct select * from conflict */select Member.name,member.mail,userinfo.city,userinfo.birthday into Member_backup from Memberinner join userinfo on member.id = Userinfo.id;select * from Member_backup;select * from member I Nner Join userinfo on member.id = userinfo.id;

MySQL Table Backup