RE: String and integer in SQL statement

> I create a table, one field is integer type. > I don't know why the following statements work : > > select * from table1 where field1 = 3; > select * from table1 where field1 = '3'; In the second case, MySQL automatically casts '3' to 3. --

String and integer in SQL statement

I create a table, one field is integer type. I don't know why the following statements work : select * from table1 where field1 = 3; select * from table1 where field1 = '3'; - Before posting, please check: http://www.mysql.c