At 08:00 AM 4/25/01 +0200, Herman Wapenaar wrote:
>I am using a website based in the states to which is PHP enabled. I am
>using MySQL.
>
>Is there a way to create a table with PHP? I do not see any command for that.
Well, as an Oracle administrator, I may be going out on a limb here
regarding MySQL, but doesn't it accept standard SQL syntax to create, alter
or drop tables?
CREATE TABLE abc AS SELECT * FROM def WHERE ghi LIKE '%jkl';
(to copy some elements from one table to a new table)
CREATE TABLE test (col1 NUMBER NOT NULL PRIMARY KEY,
col2 CHAR(2) NOT NULL);
ALTER TABLE test ADD col3 NUMBER(5) NOT NULL;
DROP TABLE test;
- Brian
-------------------------------------
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
<[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]