How to solved this error?

Question

1.00/5 (1 vote)

See more:

Error Code: 1366. Incorrect integer value: 'null' for column 'HomeTeamScore' at row 1

I am using MySQL Workbench 8.0

this is my code:

INSERT INTO season
(Season,PlayDate,HomeTeam,HomeTeamScore,AwayTeam,AwayTeamScore)
VALUES
('1','2020-07-12','1011','null','1017','null');

What I have tried:

I when I changed 'NULL' to '0' it works but I want it to say 'NULL' not 0.

Posted 18-Nov-20 19:22pm

Member 14677197

Updated 18-Nov-20 20:38pm

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2020-11-18T20:38:00

Solution 1

Try like this:

Copy Code

INSERT INTO season
(Season,PlayDate,HomeTeam,HomeTeamScore,AwayTeam,AwayTeamScore)
VALUES
('1','2020-07-12','1011',NULL,'1017',NULL);

Your table must allow null values on these fields.

Permalink

Posted 18-Nov-20 20:38pm

RickZeeland

How to solved this error?

1 solution

Solution 1

Add your solution here

Preview 0

How to solved this error?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us