[RESOLVED] copy table from one to another

learnphp1

I want to make an exact copy of a table in the same database...
i am trying the belwo query. but gives an error message


$sqlCopy = "SELECT *
					INTO ratecodes_TEST
					FROM ratecodes_stagging";

error is

Error: [256] Could not query table: Undeclared variable: ratecodes_TEST
Query: SELECT * INTO ratecodes_TEST FROM ratecodes_stagging

Thanks in advance

bradgrafelman

Read the manual for the SELECT ... INTO statement and you'll find:

MySQL Manual wrote:
SELECT ... INTO syntax enables selected columns to be stored directly into variables.

(emphasis added).

As the error message suggests, 'ratecodes_TEST' isn't a variable (in fact, it's probably a table according to your description). Thus this syntax doesn't apply to what you're trying to do.

You've got two options:

Do the copying directly from the CREATE TABLE query (see the 'select_statement' towards the bottom of the function prototype in the MySQL manual).
If the table is already created, use the INSERT ... SELECT syntax.

dagon

CREATE table t2 like t1;
INSERT t2 SELECT * FROM t1;