Problem with SELECT INTO statement

132591 · November 24th, 2006, 04:01 PM

What is wrong with this code?

Code:

<?php
    $con = mysql_connect("mysql157.secureserver.net","132591","lotrt2t");
    if(!con){
        die("Hey, you with the eyes, check your connection.");
    }

     mysql_select_db("132591");

    $sql = "CREATE TABLE backupuser(
                user varchar(12),
                password varchar(12)
            )";
    mysql_query($sql, $con);

    $sql = "SELECT * INTO backupuser FROM users ";
    mysql_query($sql, $con);
?>

The SELECT * INTO userbackup FROM users is not working. It acts as though I did not even put it there.

"Judge a man by his questions, not by his answers."
-Voltaire

happygv · November 27th, 2006, 06:58 AM

SELECT INTO always creates a TABLE that is of the structure of the Columns put up in the SELECT INTO statement. But you seem to create the destination table and then use the SELECT INTO, that is why it is erring out.

If the table already exists, you should use INSERT INTO, instead of SELECT INTO. INSERT INTO, inserts the resulting rows in to an existing table.

Hope that clarifies.
Cheers.

_________________________
- Vijay G
Strive for Perfection