Skip to content
Advertisement

Tag: sql-insert

MySQL INSERT inserting BIT to 1 instead of 0

I have the following query which should insert a 0 but instead inserts 1. It is executed with prepared statements in PHP: All inserts are performed fine, except a 1 is inserted in column6 instead of a 0. Column 6 has the datatype BIT. The query works fine, however, when executing directly in the phpmyadmin ‘MySQL’ tab. What am I

Sql arithmetic overflow

I have this query: Insert into Course(name,age,id,facebookuser) Values(‘Example’,25,204813,blalbla@walla.com), (‘Exmnumtwo’,35,504813,email@walla.com) Which gives me the error 8115: “arithmetic …

Advertisement