03.04.2016, 16:19
Quote:
|
You have indeed specified column "origicloc" not to be null. That's why you get this error. MySQL is basically telling you there's a column which is not allowed to be null. But you're basically entering 'null' as content/data for that column. You'll have to give that column a default value, or enter a value for that column in the query, or you'll have remove the NOT NULL constraint.
Replacing Код:
origloc VARCHAR(30) NOT NULL Код:
origloc VARCHAR(30) NOT NULL DEFAULT '' Код:
INSERT INTO `users` (`username`,`password`,`origloc`) VALUES ('%s','%s','any content here')
|


