I am using phpmyadmin and I want to add a new field and then set the defualt value to all the values to "a". How do I do a mass insert and not just create a big empty table row?
The filed is called AREA it is a varchar of LENGTH 5 it should be NOT NULL and have a default value of "a" This is fine when I create the field and add new entries but the old ones have a nothing in them. Thanks, Ross