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]

Reply via email to