Re: FN-FORUM: PHP/MySQL question

date posted 10th August 2003 15:52

Ah, except the [LIKE] option is only valid for MySQL 4.1 and above. Not
available in 4.0.1. And the message simply indicates a parsing error.

Thanks, though.

John
----- Original Message -----
From: "Niina Talikka" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, August 10, 2003 3:45 PM
Subject: Re: FN-FORUM: PHP/MySQL question


>
> 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 ]
>
>
> ==========
> fido.net are pleased to sponsor these Freelancers messages. For all
> your web hosting needs check out http://www.fido.net/ with hosting
> packages starting from just £46.95 a year including VAT.
> Free 0871 Fax2Email numbers also available online!
> http://www.fido.net/ - the internet made simple! - 0800 1072 666
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>