Working Around SELECT INTO for mySQL

mySQL does not support the "SELECT * FROM ... INTO ..." sybase SQL extension. That seemed a real bummer for me since I use that a lot in my work and wanted to use it while I was trying to repair my cocktail recipe database which was full of rubbish because I don't check the input to the table.

After a bit of searching around I found that you could replicate this in two simple ways outlined below:

Using the CREATE ... SELECT Method

This is a really simple way to fix the problem, if you have experience with the existing "SELECT" method you can use that to create a new table with exactly the same properties as the table you are selecting from. An example statement below would copy exactly the table tbl_Ingredients from a cocktail database across to the placement tbl_Ingredients_temp.

CREATE tbl_Ingredients_temp SELECT * FROM tbl_Ingredients

In fact this method is really flexible since you can insert any column you wish into the new table. For example if you wanted to add a new column which allowed you to announce if an ingredient had been added after the new version you could (the values in that column will all be NULL for exising ingredients).

CREATE tbl_Ingredients_temp (A_INT_newversion INT) SELECT * FROM tbl_Ingredients

This made my life a lot easier and I hope it makes your life easier too.

Comments

[Kamagra]

I should say this method help me a lot to fix the problems I was having with this system. I was enhancing my dessert recipes database, but I had not idea which the correct manner to repair it was. Fortunately this is a good solution, because that problem was freaking me out.

[Buy Viagra]

Oh I want to have a cocktail recipes database it sounds great, because if somebody visit you, you can prepare them any cocktail of your list, I think that it is a very cool idea and is very functional. I will do my own database but with all the dishes that I can prepare.

[Alana]

Thanks for the read. I agree with the points you made. http://www.rapidmediafire.com also has peoples thoughts on the matter.

[Ben Mearns]

@jamal, should be:

CREATE TABLE temp_blog SELECT ID, blog_id FROM 'se_posts'

notice "CREATE TABLE temp_blog ..." rather than "CREATE temp_blog ..."

[jamal]

Pls help me that sql is not run
CREATE temp_blog SELECT ID, blog_id FROM `se_posts`

why not its run?