You are misunderstanding the 'IN' operator
Try and think of it this way
SELECT value from table where field in (1,2,3)
is the same as
SELECT value from table where field = 1 or field = 2 or field = 3
So in you case
SELECT Count(ID) FROM ZipCounty WHERE '528' IN (VendorLink);
is
SELECT
Another option is to have another table with the item name and number
using that as a lookup table.
IMHO it all depends on the data if the select is static (or rarely
changes) an enum would be best. If is changes a lot then I would use
another table to store it in.
-Michael
I protect you,
I don't really think this can be done, but I figured that I would ask
anyways
I want 3 mysql server running (A,B and C)
I want only one table from A to replicate to B
and I want all of B but the one table from A to replicate to C
and I want C to replicate back to B
-Michael
This marks
I am unable to set thread_cache_size via the mysql tool.
Should I be able to?
Am I doing something wrong?
Ver: 3.23.51
mysql set option thread_cache_size=4M;
ERROR 1064: You have an error in your SQL syntax near
'thread_cache_size=4M' at line 1
mysql set thread_cache_size=4M;
ERROR 1064: You
alive, you dolt.
-Nathan
On Thu, 29 May 2003, Egor Egorov wrote:
mtoth [EMAIL PROTECTED] wrote:
I am unable to set thread_cache_size via the mysql tool.
Should I be able to?
Am I doing something wrong?
Ver: 3.23.51
You could do it only editing my.cnf file or run mysqld
what does
Select count(id) from t_calllog_calls where id IS NULL
give you?
On Tue, 17 Sep 2002, Richard Unger wrote:
That would just give me 1994 for all 3 columns of output. What I want to know is
how many calls were longer than 5 seconds, how many were = 5 seconds, and the total
number
Is call_end - call_start a integer, maybe the range is to big and it is
eval'd as NULL or false. shrug.
On Tue, 17 Sep 2002, Gelu Gogancea wrote:
Hi,
One thing I'd check: what happens if t_calllog_calls.id is NULL?
...is not count.
Regards,
Gelu
I had that once and it was due to the fact that the data I was trying to
put into the database was bigger the 1M (1M is the default) per insert
I had to start mysqld with ' -O max_allowed_packet=3M'
On Mon, 9 Sep 2002, louie miranda wrote:
I got the file using load data infile (transfer)