Re: FN-FORUM: PHP/MySQL question

date posted 10th August 2003 15:17

John wrote:
>I'm trying to use the CREATE [TEMPORARY] TABLE command in MySQL in a PHP
>file, but I keep getting a parsing error.
>
> >CREATE TABLE T_Temp SELECT FROM T_Members;


I've not used temporary tables but looking at
http://www.mysql.com/doc/en/CREATE_TABLE.html i think you need to use the
following:

CREATE TEMPORARY TABLE T_Temp LIKE T_Members

Does it not spit out an error message that might be of some help?


Niina


[EMAIL REMOVED] : http://www.ktobe.com
[ phone: 020 8539 2680 ] [ fax: 0871 433 8446 ]