INSERT syntax query

[blinks]

The following code won't work -

 

$insert = "INSERT INTO temp_wild *

SELECT *

FROM pokemon_data

WHERE pokemon_name = '$pkfind'"

$result =  mysql_query($insert) or die(mysql_error());

 

although it will if I replace the first '*' with all the individual column names. But there are a lot of columns, and I don't want to specify them all. Is it possible to use '*' or something else to signfiy "all" in the above query?

 

TIA

[fenway]

You don't get a choice -- specify them -- typing is easy.

[jdavidbakr]

If your table structure is the same you should be able to:

 

$insert = "INSERT INTO temp_wild
SELECT *
FROM pokemon_data
WHERE pokemon_name = '$pkfind'"
$result =  mysql_query($insert) or die(mysql_error());