mysql failed query question..
#6

Quote:
Originally Posted by Bakr
View Post
NULL basically means nothing, or empty, so it makes sense to be there if there is no value for that field!

Anyway, you may have set up your table to default the values to NULL.
Wrong.

NULL is not the number zero.
NULL is not the empty string (“”) value.

NULL means unknown - hence the problem with MySQL loading an unknown.

Just hold on, I'm trying to figure out the problem. It COULD be that you've done this ... WHERE `value` = '%' (for example, the point is the lack of string definer (sorry my terminology is bad))
Reply


Messages In This Thread
mysql failed query question.. - by lolumadd_ - 22.08.2011, 00:41
Re: mysql failed query question.. - by Kar - 22.08.2011, 01:47
Re: mysql failed query question.. - by lolumadd_ - 22.08.2011, 01:51
Re: mysql failed query question.. - by Bakr - 22.08.2011, 01:52
Re: mysql failed query question.. - by lolumadd_ - 22.08.2011, 01:54
Re: mysql failed query question.. - by Antonio [G-RP] - 22.08.2011, 02:13
Re: mysql failed query question.. - by Bakr - 22.08.2011, 02:17
Re: mysql failed query question.. - by lolumadd_ - 22.08.2011, 02:31
Re: mysql failed query question.. - by Kar - 22.08.2011, 03:17
Re: mysql failed query question.. - by lolumadd_ - 22.08.2011, 03:29
Re: mysql failed query question.. - by Kar - 22.08.2011, 03:35
Re: mysql failed query question.. - by lolumadd_ - 22.08.2011, 04:08
Re: mysql failed query question.. - by Kar - 22.08.2011, 04:29
Re: mysql failed query question.. - by lolumadd_ - 22.08.2011, 04:55
Re: mysql failed query question.. - by [HiC]TheKiller - 22.08.2011, 07:03

Forum Jump:


Users browsing this thread: 1 Guest(s)