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

05/21/2020 - 23:08
inticleni (not verified)

cbd pills hemp cbd oil buy cbd cbd vape http://buycbdoilonline.us.com/ - cbd oil for pain

05/21/2020 - 23:25
enetibliole (not verified)

http://cbdoilrx.us.com/ cbd store best cbd oil cbd oil for pain cbd capsules

05/22/2020 - 05:25
inticleni (not verified)

cbd pills cbd oil at walmart cbd oil for pain hemp oil for pain

05/22/2020 - 06:18
enetibliole (not verified)

cbd capsules http://cbdoilrx.us.com/ - hemp oil for pain cbd hemp cbd oil at walmart

05/22/2020 - 11:58
inticleni (not verified)

hemp cbd http://buycbdoilonline.us.com/ - cbd online hemp oil for pain cbd for sale cbd gummies

05/22/2020 - 18:25
inticleni (not verified)

cbd oil for sale http://buycbdoilonline.us.com/ - cbd oil for pain cbd near me cbd oil at walmart cbd oil for dogs

05/23/2020 - 00:52
inticleni (not verified)

http://buycbdoilonline.us.com/ buy cbd http://buycbdoilonline.us.com/ - cannabis oil hemp cbd

05/23/2020 - 07:27
inticleni (not verified)

cbd oil for pain cbd products cbd pure

05/23/2020 - 12:19
male erection pills (not verified)

Tkkppt adkrrc cheap erectile dysfunction pill best otc ed pills

05/25/2020 - 09:38
erection pills ... (not verified)

Efjwbs lahtjx ed pills that work men's ed pills

05/27/2020 - 06:04
best erectile d... (not verified)

Drlxfg ptjbud medicine for erectile best ed pills at gnc

05/29/2020 - 10:34
best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

05/29/2020 - 10:37
best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

05/29/2020 - 10:38
best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

05/29/2020 - 10:39
best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

05/31/2020 - 09:10
Estherchera (not verified)

Emohtg rysvdo Free viagra sample Overnight canadian viagra

06/08/2020 - 16:38
bisding (not verified)

mezclar viagra y alcohol https://buyciallisonline.com/ - Cialis Cialis 2.5mg Buy Cialis Z Pack Generic Zithromax Online

06/10/2020 - 18:11
Estherchera (not verified)

Ltfxdh hdoncw canada online pharmacy pharmacy online

06/11/2020 - 14:16
Estherchera (not verified)

Lucuia hozsdo pharmacy online canada pharmacy

06/11/2020 - 14:18
Estherchera (not verified)

Lucuia hozsdo pharmacy online canada pharmacy

06/12/2020 - 10:07
Estherchera (not verified)

Znxtbn ftvvnq canadian pharmacy online canada pharmacy

06/13/2020 - 15:33
Estherchera (not verified)

Rwtfkr titnfg viagra online Generic viagra canada

06/14/2020 - 11:07
Estherchera (not verified)

Wlgpar tcwjwp viagra online Cialis or viagra

06/15/2020 - 06:00
Estherchera (not verified)

Mlosnu whjhmv Buy viagra Viagra australia

06/15/2020 - 06:02
Estherchera (not verified)

Mlosnu whjhmv Buy viagra Viagra australia

06/16/2020 - 03:21
Estherchera (not verified)

Epzkig bziemi Free trial of viagra canadian pharmacy online

06/16/2020 - 20:40
Estherchera (not verified)

Uxnnxo sesfxy Buy online cialis pharmacy online

06/17/2020 - 16:00
Estherchera (not verified)

Bycsmv tvmnel Buy cialis online canadian pharmacy

06/18/2020 - 09:19
Estherchera (not verified)

Ywzmge eoidmt Buy cialis canada pharmacy

06/18/2020 - 09:20
Estherchera (not verified)

Ywzmge eoidmt Buy cialis canada pharmacy

06/19/2020 - 04:41
Brand name viagra (not verified)

Uzvjlw nqnqas levitra 20mg

06/19/2020 - 22:50
Buy viagra cheap (not verified)

Hjgqdo nzxtkj vardenafil

06/20/2020 - 16:32
Buy viagra now (not verified)

Xtprwu ualxyx vardenafil pill

06/21/2020 - 11:27
Pfizer viagra canada (not verified)

Lqoaly tzbwrd order levitra cheapest ed pills online

06/22/2020 - 05:25
Buy viagra in canada (not verified)

Mtxknj owgoai kamagra jelly amazon ed meds online without doctor prescription

06/22/2020 - 05:26
Buy viagra in canada (not verified)

Mtxknj owgoai kamagra jelly amazon ed meds online without doctor prescription

06/23/2020 - 01:12
Pfizer viagra 5... (not verified)

Yvglxf cwigby hollywood casino online empire casino online

06/23/2020 - 13:45
Buy viagra lowe... (not verified)

Ekwadc klqyty vardenafil generic canadian online pharmacy

06/23/2020 - 13:47
Buy viagra lowe... (not verified)

Ekwadc klqyty vardenafil generic canadian online pharmacy

06/23/2020 - 21:35
Viagra brand (not verified)

Rxihrx tbyica online casinos real casino online

06/24/2020 - 21:25
phefewedy (not verified)

Mejor Cialis Viagra [url=https://cheapcialisll.com/]Cheap Cialis[/url] Cialis Prezzo Al Pubblico Cheap Cialis Amoxicillin Cats Sick

06/24/2020 - 22:25
Buy viagra brand (not verified)

Goclnb qrnwpr propecia for hair loss online ed pills

06/25/2020 - 08:23
Sample viagra (not verified)

Becojb ymxjjq cialis prices best online pharmacy

06/25/2020 - 08:25
Sample viagra (not verified)

Becojb ymxjjq cialis prices best online pharmacy

06/26/2020 - 03:46
Us discount via... (not verified)

Yhnmiy ahmhyy cheapest generic viagra over the counter erectile dysfunction pills

06/26/2020 - 03:47
Us discount via... (not verified)

Yhnmiy ahmhyy cheapest generic viagra over the counter erectile dysfunction pills

06/27/2020 - 06:17
Generic viagra us (not verified)

Rlzmtw ohnvja generic viagra 100mg over the counter erectile dysfunction pills

06/28/2020 - 03:27
phefewedy (not verified)

Diabecon https://agenericcialise.com/ - buying cialis online reviews Where Purchase Flagyl In Virgin Islands Cialis Shipped Ups Worldwide Stendra Discount From Canada

06/28/2020 - 03:29
phefewedy (not verified)

Diabecon [url=https://agenericcialise.com/]buying cialis online reviews[/url] Where Purchase Flagyl In Virgin Islands Cialis Shipped Ups Worldwide Stendra Discount From Canada

06/28/2020 - 06:45
Viagra 50 mg (not verified)

Xklycg hhbvbp real money casino real casinos online no deposit

Add new comment