The forums have permanently moved to This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.

Results 1 to 3 of 3

Thread: Modifying/Deleting mySQL tables using PHP

  1. #1

    Modifying/Deleting mySQL tables using PHP

    Hey guys, just wondering if you hav any idea how to delete, or modify (add a column) to a mySQL table, using a PHP script, so far all i can do is add data, and create the entire table using PHP.

    Thanks in advance guys, laters. Andy.

  2. #2
    column or row?

    if you want to delete a column use ALTER TABLE.

    if you want to delete a row use DELETE.


  3. #3
    PHP Code:
    ("DROP DATABASE `databasename`");
    //this will drop a database
    mysql_query("DROP TABLE `tablename`");
    //will permanently remove a table
    mysql_query("TRUNCATE TABLE `tablename`");
    //this will remove all rows inside the table
    mysql_query("ALTER TABLE `tablename` CHANGE `fieldname` `newfieldname` type DEFAULT 'default value' NOT NULL");
    //alter a tables field attributes
    mysql_query("ALTER TABLE `tablename` RENAME `newtablename` ;");
    //this will change a tables name
    mysql_query("ALTER TABLE `tablename` DROP `fieldname` ;");
    //this remove a field from inside the table

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Home About Meet the Moderators Advertise

 Link to Us


Copyright 1999 - 2012