MySQL Column cannot be null
Closed
MeizaelRane
Posts
1
Registration date
Wednesday March 11, 2015
Status
Member
Last seen
March 11, 2015
-
Mar 11, 2015 at 09:29 AM
Ealhsige Posts 1 Registration date Wednesday March 18, 2015 Status Member Last seen March 18, 2015 - Mar 18, 2015 at 11:25 AM
Ealhsige Posts 1 Registration date Wednesday March 18, 2015 Status Member Last seen March 18, 2015 - Mar 18, 2015 at 11:25 AM
Related:
- Mysql cannot be null
- How do i auto number a column in excel? ✓ - Excel Forum
- Mysql free download - Download - Databases
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- Database connection error (1): the mysql adapter 'mysql' is not available. ✓ - Windows Forum
1 response
Ealhsige
Posts
1
Registration date
Wednesday March 18, 2015
Status
Member
Last seen
March 18, 2015
3
Mar 18, 2015 at 11:25 AM
Mar 18, 2015 at 11:25 AM
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)
