|
|
Posted by Jerry Stuckle on 07/26/06 22:37
himilecyclist@yahoo.com wrote:
> Thanks for the suggestions!
>
> The reference I am using, "Sams Teach Yourself SQL", indicates that
> SELECT * INTO can be used to copy one table to another:
>
> "To copy the contents of a table into a brand new table (one that is
> created on-the-fly) you can use the SELECT INTO statement."
>
>>From what I have read here, that is not an accurate description for
> MySQL.
>
> Our goal is some PHP code that will create a copy (for backup purposes)
> of a MySQL table residing on a production Linux server. We would like
> to create the copy on the user's local machine. Is there a better way
> to accomplish that?
>
> Thanks!
>
Different databases often have some differences in SQL implementation.
AFAIK, SELECT * INTO ... is not standard SQL, where as INSERT INTO xxx
SELECT... is.
You should always use manuals written for your particular database.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|