MySQL Column cannot be null
Closed
MeizaelRane
Posts
1
Registration date
Wednesday 11 March 2015
Status
Member
Last seen
11 March 2015
-
11 Mar 2015 à 09:29
Ealhsige Posts 1 Registration date Wednesday 18 March 2015 Status Member Last seen 18 March 2015 - 18 Mar 2015 à 11:25
Ealhsige Posts 1 Registration date Wednesday 18 March 2015 Status Member Last seen 18 March 2015 - 18 Mar 2015 à 11:25
Related:
- Mysql error 1048 column cannot be null
- Error network error occurred - Guide
- Cmos checksum error - Guide
- Ps3 error 80023017 - PS3 & PS4 Forum
- Error 491 play store - Guide
- Excel column number - Guide
1 response
Ealhsige
Posts
1
Registration date
Wednesday 18 March 2015
Status
Member
Last seen
18 March 2015
3
18 Mar 2015 à 11:25
18 Mar 2015 à 11:25
Check "SQL_MODE='STRICT_TRANS_TABLES';" exist in your my.ini
ALTER TABLE mytable MODIFY quantity NUMERIC(20, 2)
Replace NUMERIC(20, 2) with your actual datatype, but without NOT NULL constraint.
To show your current column definitions, run
SHOW CREATE TABLE mytable
in mysql (the command line client)
ALTER TABLE mytable MODIFY quantity NUMERIC(20, 2)
Replace NUMERIC(20, 2) with your actual datatype, but without NOT NULL constraint.
To show your current column definitions, run
SHOW CREATE TABLE mytable
in mysql (the command line client)
