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

viagra dosage sizes (not verified)

Canadian Viagra 400mg

zithromax purchase (not verified)

Pharmacie En Ligne Levitra

buy zithromax powder (not verified)

Zoloft Australia

over the counte... (not verified)

Fast Shipping Prednisone

dr reddy finast... (not verified)

Cialis Senza Ricetta In Svizzera

propecia side e... (not verified)

Prix Viagra 50 Mg Pfizer

cheap non presc... (not verified)

Keflex And Staph

how long does p... (not verified)

Generique De Cialis