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]