Created
March 24, 2020 23:43
-
-
Save aohorodnyk/d253cf4445bada9511ed51d11ca15398 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE t1_new LIKE t1; | |
RENAME TABLE t1 TO t1_old, t1_new TO t1; | |
INSERT INTO t1 SELECT * FROM t1_old; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment