LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   MySQL "errors 1364, 1048" (https://www.linuxquestions.org/questions/linux-general-1/mysql-errors-1364-1048-a-420470/)

ziox 02-28-2006 09:45 PM

MySQL "errors 1364, 1048"
 
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';


All times are GMT -5. The time now is 07:31 AM.