How to duplicate MySQL table quickly

Posted by admin on Thu, 09/19/2019 - 06:17

The qickest way to duplicate MySQL table.

CREATE TABLE newtable LIKE oldtable; 
INSERT newtable SELECT * FROM oldtable;

To just duplicate all structure and data:

CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
Tags: 
×

Hey! Don't miss a new cool stuff!

Comments

StevVise (not verified)

Propecia Nebenwirkungen Leber http://cialisjh.com - Buy Cialis Cheap Xenical 120 Mg Cialis Elocon 0.1%

StevVise (not verified)

Keflex And Yeast Infection http://abuycialisb.com - Buy Cialis Viagra Prix Quebec Buy Cialis Canadian Parmacy

Add new comment