mysql insert
#3

You need to wrap texts in quotes otherwise MySQL will interpret the value as a column name. You do not need to wrap in other values in quotes. While this may still work it will force the server to do an implicit conversion from a string (e.g. '42') to its type (e.g. 42).

Edit: ^ Like that.
Reply


Messages In This Thread
mysql insert - by n00el - 13.05.2014, 14:29
Re: mysql insert - by Luis- - 13.05.2014, 14:32
Re: mysql insert - by Vince - 13.05.2014, 14:34
Re: mysql insert - by n00el - 13.05.2014, 14:36
Re: mysql insert - by Luis- - 13.05.2014, 14:36
Re: mysql insert - by n00el - 13.05.2014, 14:39
Re: mysql insert - by n00el - 13.05.2014, 14:44
Re: mysql insert - by n00el - 13.05.2014, 15:11
Re: mysql insert - by Madd92 - 13.05.2014, 15:28
Re: mysql insert - by n00el - 13.05.2014, 15:32

Forum Jump:


Users browsing this thread: 3 Guest(s)