MySQL "errors 1364, 1048"

ziox · 02-28-2006, 09:45 PM

Hi
I've that problem
_________________________

mysql> insert into user (host, user,password)
-> values ("localhost", "someone", password(""));
ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
mysql> insert into user (host, user,password, ssl_cipher)
-> values ("localhost", "someone", password(""), null);
ERROR 1364 (HY000): Field 'x509_issuer' doesn't have a default value
mysql> insert into user (host, user,password, ssl_cipher, x509_issuer)
-> values ("localhost", "someone", password(""), null, null);
ERROR 1364 (HY000): Field 'x509_subject' doesn't have a default value
mysql> insert into user (host, user,password, ssl_cipher, x509_issuer, x509_subject)
-> values ("localhost", "someone", password(""), null, null, null);
ERROR 1048 (23000): Column 'ssl_cipher' cannot be null
___________________________
and I found that there are alot have the same thing but I couldn't find a clear answer
Is there a way to set a defualt values for every thing?
any suggestions?
Thanks

j-ray · 03-01-2006, 01:58 AM

alter table user set ssl_cipher varchar(30) null default 'whatever';