开发者

How to fix the error blob/text field cant have default value in Phpmyadmin

开发者 https://www.devze.com 2023-02-18 12:11 出处:网络
I was trying to add an field to the existing table its of type TEXT ,But i am getting an error t开发者_C百科ext field cant have default values.please help me to the solve this issue.When creating the

I was trying to add an field to the existing table its of type TEXT ,But i am getting an error t开发者_C百科ext field cant have default values.please help me to the solve this issue.


When creating the new column do not set the TEXT field to have a default value.

I quote this line from http://dev.mysql.com/doc/refman/5.0/en/blob.html

BLOB and TEXT columns cannot have DEFAULT values.
0

精彩评论

暂无评论...
验证码 换一张
取 消