It's legal to create with a SELECT; look at section 7.7 of the manual.

-----Original Message-----
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 3:04 PM
To: Ivo Stoykov; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] PHP-MySQL create table problem


Maybe it's just me but I've never seen anyone create a table by using a
Select statement.  Have you verified that you can do this? (like you've
checked the manual and this construct is supported?)

Cal
http://www.calevans.com


-----Original Message-----
From: Ivo Stoykov [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 3:37 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP-MySQL create table problem


Hello

I have following problem and really need your help.

I'm trying to create a new table using  "CREATE TABLE partlist_back SELECT *
FROM partlist" from a php script. The new table have to be based on an
existing table. On the machiene I test it works fine when I upload it on the
server I receive a query error!

Please help me!

Ivo



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to