Re: adding a field and settign the value

2006-04-19 Thread Shawn Green
--- [EMAIL PROTECTED] wrote: > 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 > NUL

adding a field and settign the value

2006-04-19 Thread ross
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