a guest Jun 16th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE x LIKE real;  -- or use a regular CREATE.
  2. LOAD DATA ... INTO x;
  3. RENAME TABLE real TO old, x to REAL;
  4. DROP TABLE x;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand