Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Worcester, MA
    Posts
    62

    A little phpmyadmin help

    Hello,

    I have a bit of a problem in my database, i created about 140 tables and realized I set them as not null so i cant insert a empty form. I need to change to NULL.

    Is there a command to just change all tables from NOT NULL to NULL DEFAULT ? Any help would be most appreciated, thanks.
    Worcester Web Design
    Your solution for affordable, php scripting and website development.
    worcesterwideweb.com

  2. #2
    Join Date
    Jul 2004
    Location
    Worcester, MA
    Posts
    62
    Thought it would be something like this

    ALTER TABLE 'clients' NULL DEFAULT "0";

    But it doesnt seem to work
    Worcester Web Design
    Your solution for affordable, php scripting and website development.
    worcesterwideweb.com

Posting Permissions

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