RE: [PHP-DB] PHP-MySQL create table problem

It's legal to create with a SELECT; look at section 7.7 of the manual. -----Original Message----- From: Cal Evans [mailto:cal@calevans.com] Sent: Monday, March 12, 2001 3:04 PM To: Ivo Stoykov; php-db@lists.php.net 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:u1067@plov.omega.bg.com] Sent: Monday, March 12, 2001 3:37 PM To: php-db@lists.php.net 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net