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: 
mysql
×

Hey! Don't miss a new cool stuff!

Comments

11/04/2021 - 18:54
Cialis (not verified)

comprar viagra sin receta medica espana

11/05/2021 - 01:17
Cialis (not verified)

Will Cephalexin Cure Staph

11/05/2021 - 07:30
Lasix (not verified)

Preis Viagra 50 Mg Pfizer

11/06/2021 - 22:03
purchase cialis (not verified)

Secure Progesterone Hormone Replacement Low Price Mastercard Nevada

11/07/2021 - 05:50
lasix for dog w... (not verified)

Flagyl Buy Online

11/07/2021 - 08:21
generic for lasix (not verified)

viagra generico precio en farmacias

11/08/2021 - 08:13
propecia vs gen... (not verified)

viagra pfizer

11/08/2021 - 14:56
how long will v... (not verified)

Levitra Perime

11/08/2021 - 15:37
Lasix (not verified)

Antibiotic Keflex And The Liver

11/09/2021 - 00:27
propecia (not verified)

kamagra primobolan

11/09/2021 - 00:47
Lasix (not verified)

Canada Pharmacy 24

11/09/2021 - 13:48
viagra bodybuilding (not verified)

Cialis Y La Ceguera

11/10/2021 - 10:02
buy priligy in usa (not verified)

cialis does not work anymore

11/11/2021 - 02:05
priligy 30mg (not verified)

Cost Of Viagra Pills

11/11/2021 - 07:53
Prednisone (not verified)

buy cialis super active plus canada

11/11/2021 - 12:09
Priligy (not verified)

Cialis 5 Mg Precio Vademecum

11/11/2021 - 13:51
Stromectol (not verified)

Propecia Hairy Back

11/12/2021 - 16:25
lowest priced viagra (not verified)

Vendita Viagra Catania

11/13/2021 - 01:51
Viagra (not verified)

Amoxicillin Dose Adult Strep Throat

11/14/2021 - 22:32
buy prednisone cream (not verified)

Viagra Gold Usa

11/15/2021 - 00:04
Prednisone (not verified)

mdma and cialis

11/15/2021 - 07:59
prednisone side... (not verified)

Viagra Healthy Man

11/15/2021 - 17:54
Prednisone (not verified)

Propecia Torsion Testicular

11/15/2021 - 22:00
Priligy (not verified)

Purchase isotretinoin pills next day pharmacy amex

11/16/2021 - 10:21
dapoxetina generico (not verified)

Cipan Portugal Amoxicillin

11/16/2021 - 21:08
Priligy (not verified)

Amoxicillin 1000mg Bid

12/03/2021 - 18:02
where can i buy... (not verified)

buy now isotretinoin - isotretinoin cash delivery

12/03/2021 - 18:46
plaquenil cost ... (not verified)

Propecia Soft Propecia

12/03/2021 - 20:01
zithromax z-pack (not verified)

Costco Pharmacy Cialis Prices

12/03/2021 - 21:21
buy zithromax n... (not verified)

Generic Viagra Accepts American Express

12/04/2021 - 07:08
generic cialis ... (not verified)

Clomid Hyperstimulation

12/04/2021 - 11:57
z pack for sale... (not verified)

cialis message board

12/04/2021 - 17:12
how do a zithro... (not verified)

Stendra Ed Saturday Delivery

12/05/2021 - 01:09
buy cheap ciali... (not verified)

Dutasteride Overseas Mastercard Accepted

12/07/2021 - 00:30
generic cialis cost (not verified)

picture of kamagra st

12/07/2021 - 02:34
gabapentin vs lyrica (not verified)

Lasix Delivered Overnight

12/07/2021 - 06:01
buy cialis onli... (not verified)

Generic Doxycycline Pills

12/07/2021 - 09:55
cialis generic ... (not verified)

Onlinedrugstore Canada

12/07/2021 - 17:55
gabapentin dosage (not verified)

Viagra Montreal A Vendre

12/07/2021 - 18:13
cialis order online (not verified)

Cialis Pressione Alta

12/08/2021 - 05:53
gabapentin 800mg (not verified)

cialis web page

12/09/2021 - 11:38
cialis for daily use (not verified)

Costo Cialis One Day

12/09/2021 - 13:23
gabapentin for ... (not verified)

Le Cialis Original

12/09/2021 - 13:24
gabapentin for ... (not verified)

Le Cialis Original

12/09/2021 - 16:44
is gabapentin a... (not verified)

Viagra 100mg Prix Pharmacie

12/09/2021 - 22:03
gabapentin drug... (not verified)

Amoxicillin In Pigs

12/18/2021 - 20:08
finpecia for sale (not verified)

How To Get Narcotics Online

12/19/2021 - 10:51
finasterid (not verified)

is cialis better than viagra

12/19/2021 - 16:16
buy azithromyci... (not verified)

Is Amoxicillin Available In A Patch

12/19/2021 - 21:11
can i buy zithr... (not verified)

Cheap Antibiotics Amoxicillin