The forums have permanently moved to forum.kirupa.com. 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.

    peace

  3. #3
    PHP Code:
    <?php
    mysql_query
    ("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
     
    ?>
    Last edited by binime; March 5th, 2005 at 05:33 AM.

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 kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012