it themes to me, that you've mysqls strict mode not enabled. If I run your example I get mysql error #1366, because '' is not a valid integer value.
Disabling mysqls strict mode is absolutely no option in production. None of your examples should work in a productiv environment. A valid query for your table definition should look like this:
INSERT INTO `mazzo` (`id`, `idgiocatore`, `idcarta`) VALUES
(null, 0, 0);
Hi David,
it themes to me, that you've mysqls strict mode not enabled. If I run your example I get mysql error #1366, because '' is not a valid integer value.
Disabling mysqls strict mode is absolutely no option in production. None of your examples should work in a productiv environment. A valid query for your table definition should look like this:
INSERT INTO `mazzo` (`id`, `idgiocatore`, `idcarta`) VALUES
(null, 0, 0);