mysql copy table

Continuing my chain of blatantly obvious mysql queries that I nonetheless didn't know at one stage :) copying a table isn't an obvious function in mySQL. So here's how to do a mysql copy table

Say you have a table called "tbl_theoriginal" which has the perfect, ideal, wonderful table structure for a new table you want "tbl_thenewone" and you would like to create it the query you would create is as follows:

CREATE tbl_thenewone SELECT * FROM tbl_the original

Simple huh! You can put in any WHERE clause you like and even a limit 1,1 or whatever if you don't want to transfer any content but just the table structure.

Comments

[ugg bags]

good blog,I like it very much, give me very good mood.

[ugg gloves]

good blog,I like it very much, give me very good mood.

[ugg shoes]

It should be the dream of many to purchase a pair of bailey boots from UGG during the upcoming festive season. The comfort and top quality element in the boots is incomparable, it is correct but the way the footwear combines glamour, fashion along with consolation and high quality that's unparallel in correct terms. These boots are wonderful attribute to your feet all through winter season and you'll be able to incredibly nicely wear it to maintain your ft warm even if the temperature is below freezing point. The boots will even prevent your feet from drying out and they are kept cosy through the cold days of winter. Consequently, if you would like to en joy the winter to the fullest and in a model then the boots from UGG will be the answer to your wish

[ugg shoes]

It should be the dream of many to purchase a pair of bailey boots from UGG during the upcoming festive season. The comfort and top quality element in the boots is incomparable, it is correct but the way the footwear combines glamour, fashion along with consolation and high quality that's unparallel in correct terms. These boots are wonderful attribute to your feet all through winter season and you'll be able to incredibly nicely wear it to maintain your ft warm even if the temperature is below freezing point. The boots will even prevent your feet from drying out and they are kept cosy through the cold days of winter. Consequently, if you would like to en joy the winter to the fullest and in a model then the boots from UGG will be the answer to your wish

[ugg shoes]

It should be the dream of many to purchase a pair of bailey boots from UGG during the upcoming festive season. The comfort and top quality element in the boots is incomparable, it is correct but the way the footwear combines glamour, fashion along with consolation and high quality that's unparallel in correct terms. These boots are wonderful attribute to your feet all through winter season and you'll be able to incredibly nicely wear it to maintain your ft warm even if the temperature is below freezing point. The boots will even prevent your feet from drying out and they are kept cosy through the cold days of winter. Consequently, if you would like to en joy the winter to the fullest and in a model then the boots from UGG will be the answer to your wish

[ugg shoes]

It should be the dream of many to purchase a pair of bailey boots from UGG during the upcoming festive season. The comfort and top quality element in the boots is incomparable, it is correct but the way the footwear combines glamour, fashion along with consolation and high quality that's unparallel in correct terms. These boots are wonderful attribute to your feet all through winter season and you'll be able to incredibly nicely wear it to maintain your ft warm even if the temperature is below freezing point. The boots will even prevent your feet from drying out and they are kept cosy through the cold days of winter. Consequently, if you would like to en joy the winter to the fullest and in a model then the boots from UGG will be the answer to your wish

[lacoste shoes]

Friendship is like earthenware: once broken, it can be mended; love is like a mirror: once broken, that ends it.Do you understand?

[DunlapJillian31]

Following my own analysis, billions of people in the world receive the mortgage loans from various creditors. Thus, there's a good possibility to get a commercial loan in every country.

[DAST]

To copy indexes use something like this:

CREATE TABLE tbl_thenewone (PRIMARY KEY (indexedfield)) SELECT * FROM tbl_theoriginal

[Dan K]

Doesn't work. Indexes don't get copied. (Realized this when my queries were suddenly very s...l...o...w...)