php - MySQL - 小数不能为 NULL

Question

每次我尝试在我的数据库中插入语句时，我都会收到“不正确的十进制值:第 1 行的‘bounty3’列为‘NULL’”错误。如何将空值插入十进制数据类型？我应该只将默认值设置为 0.00 吗？

Incorrect decimal value: '' for column 'bounty3' at row 1 Whole query: INSERT INTO songs (userid, wavURL, mp3URL, genre, songTitle, BPM, insWanted, bounty, insWanted2, bounty2, insWanted3, bounty3, insWanted4, bounty4, insWanted5, bounty5, insWanted6, bounty6, insWanted7, bounty7, insWanted8, bounty8, insWanted9, bounty9, insWanted10, bounty10) VALUES ('12534545', '/audio/wav/jqmrgpfcMichael/135259578210secreason.wav', '/audio/mp3/jqmrgpfcMichael/135259578210secreason.mp3', 'Rock/Funk', 'titlee', '120', 'bass', '20.00', 'guitar', '20.00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')

我也用 NULL 值尝试过这个语句。这是错误:

Incorrect decimal value: 'NULL' for column 'bounty3' at row 1 Whole query: INSERT INTO songs (userid, wavURL, mp3URL, genre, songTitle, BPM, insWanted, bounty, insWanted2, bounty2, insWanted3, bounty3, insWanted4, bounty4, insWanted5, bounty5, insWanted6, bounty6, insWanted7, bounty7, insWanted8, bounty8, insWanted9, bounty9, insWanted10, bounty10) VALUES ('12534545', '/audio/wav/jqmrgpfcMichael/143922765110secreason.wav', '/audio/mp3/jqmrgpfcMichael/143922765110secreason.mp3', 'Rock/Funk', 'title', '110', 'bass', '110.00', 'guitar', '20.00', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL')

Answer 1

哦..你正试图将一个空字符串 '' 插入到 bounty3 中。将其替换为 NULL。我还注意到其他可能数值的空字符串，例如 bonty4。对于数值，您应该将所有空字符串替换为 NULL。

例如:mysql_query("INSERT INTO empty_number,number VALUES(NULL,1)");

编辑:嘿嘿，明白了，你不能将 NULL 作为“NULL”插入到数值中，因为这是一个字符串，你应该插入为 NULL，不带任何引号