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

inticleni (not verified)

buy hemp oil best cbd oil cdb oils

inticleni (not verified)

buy hemp oil best cbd oil cdb oils

inticleni (not verified)

cbd for dogs http://cbdoilglk.com/ - cbd oil benefits cbd oil for dogs cbd oil for sale

inticleni (not verified)

hemp cbd buy cbd cdb oils

inticleni (not verified)

hemp cbd buy cbd cdb oils

inticleni (not verified)

cbd for dogs http://buycbdoilwalm.com/ - cbd near me cbd oil for pain cbd pills cbd vape

inticleni (not verified)

buy hemp oil cbd products cbd near me buy cbd

inticleni (not verified)

hemp oil http://buycbdoilwalm.com/ - cdb oils cbd oil cbd cbd gummies

inticleni (not verified)

http://buycbdoilwalm.com/ cbd medic http://buycbdoilwalm.com/ - hemp cbd oil buy cbd oil

inticleni (not verified)

cbd oil benefits buy cbd oil online cbd gummies cbd oil for pain

inticleni (not verified)

cbd oil benefits buy cbd oil online cbd gummies cbd oil for pain

inticleni (not verified)

cbd vape http://buycbdoilwalm.com/ cbd store cbd tinctures cbd oil benefits

inticleni (not verified)

cbd vape http://buycbdoilwalm.com/ cbd store cbd tinctures cbd oil benefits

inticleni (not verified)

cbd http://buycbdoilwalm.com/ - pure cbd oil cbd gummies walmart hemp cbd

inticleni (not verified)

cbd for sale http://buycbdoilwalm.com/ - buy cbd oil best cbd oil buy hemp oil

inticleni (not verified)

cbd near me http://buycbdoilwalm.com/ cannabis oil cbd oil store hemp cbd

buying ed pills... (not verified)

Hqvrau xiqofb cheap ed pills best erectile dysfunction pills

buying ed pills... (not verified)

Hqvrau xiqofb cheap ed pills best erectile dysfunction pills

inticleni (not verified)

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

enetibliole (not verified)

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

inticleni (not verified)

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

enetibliole (not verified)

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

inticleni (not verified)

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

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

inticleni (not verified)

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

inticleni (not verified)

cbd oil for pain cbd products cbd pure

male erection pills (not verified)

Tkkppt adkrrc cheap erectile dysfunction pill best otc ed pills

erection pills ... (not verified)

Efjwbs lahtjx ed pills that work men's ed pills

best erectile d... (not verified)

Drlxfg ptjbud medicine for erectile best ed pills at gnc

best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

best otc ed pills (not verified)

Cmqjyz dvquhq is cialis generic best erection pills

Add new comment