Using phpMyAdmin - 2.11.8.1deb1 and Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2, and I cannot create a text field that will have a default value of "Please contact the business office for further information at xxx-xxx-xxxx. Thank you." -- you get the idea.
How does one go about creating a text field in MySQL that will contain a default value every time a record is added?
Thanks!
Need to add default text value
Moderator: General Moderators
Re: Need to add default text value
If you're using phpMyAdmin, you should be able to enter a default value without any problem. What isn't working?bulgin wrote:Using phpMyAdmin - 2.11.8.1deb1 and Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2, and I cannot create a text field that will have a default value of "Please contact the business office for further information at xxx-xxx-xxxx. Thank you." -- you get the idea.
How does one go about creating a text field in MySQL that will contain a default value every time a record is added?
Thanks!
If you want to do it in SQL, that's pretty straightforward, too. Something like:
Code: Select all
...
myText VarChar(255) Default "Please contact ..."Re: Need to add default text value
working now -- I didn't put in the max characters allowed. I wouldn't have known about that unless you had shown me how to do it with sql.
All fixed.
thanks!

All fixed.
thanks!