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

Jndqweack (not verified)

[url=https://50cialmen.com/]50cialmen.com[/url] [url=https://aazmencial.com/]aazmencial.com[/url] [url=https://joicialviaed.com/]joicialviaed.com[/url]

LecfReest (not verified)

[url=https://hopeviagrin.com/]hopeviagrin.com[/url] [url=https://lightvigra.com/]lightvigra.com[/url] [url=https://xuypharmacyonline.com/]xuypharmacyonline.com[/url] [url=https://online21rxon.com/]online21rxon.com[/url] [url=https://happyrxpharmacy21.com/]happyrxpharmacy21.com[/url] [url=https://storerxpharmcanada.com/]storerxpharmcanada.com[/url]

KedReest (not verified)

[url=https://qqllviagria.com/]qqllviagria.com[/url] [url=https://ssviagriia.com/]ssviagriia.com[/url] [url=https://canadianpharmnorx.com/]canadianpharmnorx.com[/url] [url=https://ggviagll.com/]ggviagll.com[/url] [url=https://viagerkr.com/]viagerkr.com[/url] [url=https://viagriyvik.com/]viagriyvik.com[/url]

Jndqweack (not verified)

[url=https://50cialmen.com/]50cialmen.com[/url] [url=https://aazmencial.com/]aazmencial.com[/url] [url=https://joicialviaed.com/]joicialviaed.com[/url]

Llpweack (not verified)

[url=https://60lmentop.com/]60lmentop.com[/url] [url=https://viamengo.com/]viamengo.com[/url] [url=https://didoviamen.com/]didoviamen.com[/url]

LecfReest (not verified)

[url=https://hopeviagrin.com/]hopeviagrin.com[/url] [url=https://lightvigra.com/]lightvigra.com[/url] [url=https://xuypharmacyonline.com/]xuypharmacyonline.com[/url] [url=https://online21rxon.com/]online21rxon.com[/url] [url=https://happyrxpharmacy21.com/]happyrxpharmacy21.com[/url] [url=https://storerxpharmcanada.com/]storerxpharmcanada.com[/url]

AnthonyRof (not verified)

Полноценное продвижение сайтов в ТОП 10 по Москве и России от https://seo-bro.ru/ - Услуги по раскрутке сайтов в Яндекс, Google от частного SEO специалиста с кейсами!

Проверка сайта на сео оптимизацию онлайн по низким ценам!

AnthonyRof (not verified)

Полноценное продвижение сайтов в ТОП 10 по Москве и России от https://seo-bro.ru/ - Услуги по раскрутке сайтов в Яндекс, Google от частного SEO специалиста с кейсами!

Проверка сайта на сео оптимизацию онлайн по низким ценам!

KedReest (not verified)

[url=https://qqllviagria.com/]qqllviagria.com[/url] [url=https://ssviagriia.com/]ssviagriia.com[/url] [url=https://canadianpharmnorx.com/]canadianpharmnorx.com[/url] [url=https://ggviagll.com/]ggviagll.com[/url] [url=https://viagerkr.com/]viagerkr.com[/url] [url=https://viagriyvik.com/]viagriyvik.com[/url]

Llpweack (not verified)

[url=https://60lmentop.com/]60lmentop.com[/url] [url=https://viamengo.com/]viamengo.com[/url] [url=https://didoviamen.com/]didoviamen.com[/url]

Gertyyddfup (not verified)

Букмекерские конторы дающие бонусы без депозита https://promokody-bet.ru/5-promokoda-betwinner-pri-registracii-na-segodnja-besplatno.html бк конторы с бездепозитным бонусом при регистрации

Gertyyddfup (not verified)

Новые бк бонус за регистрацию https://promokody-bet.ru/5-promokoda-betwinner-pri-registracii-na-segodnja-besplatno.html бонусы за регистрацию без депозита в букмекерской

fluticasone 50m... (not verified)

trazodone usa trazodone 50mg pricetrazodone coupon trazodone canada

allegra 120mg cheap (not verified)

tolterodine no prescription tolterodine 1mg australiacheap tolterodine tolterodine online pharmacy

aldactone purchase (not verified)

acetazolamide for sale order acetazolamide 250 mgacetazolamide pharmacy cheap acetazolamide

cost of metroni... (not verified)

tolterodine otc tolterodine 2mg otctolterodine pills where can i buy tolterodine

alendronate 35m... (not verified)

how to purchase acetazolamide buy acetazolamide 250mgacetazolamide online buy acetazolamide

Add new comment