Yes! The "illegal double" error only happens if you do the select like you
did. The only error I was getting was the generic "there's an error in your
sql."
Thank you!
Bob
From: Hank [mailto:hes...@gmail.com]
Sent: Monday, December 20, 2010 11:52 AM
To: R
I am having the hardest time getting a select as statement right. Here is the
full query:
select
SUM(IF(image='EE0840D00E2ED8A317E5FA9899C48C19',1,0)) as
EE0840D00E2ED8A317E5FA9899C48C19,
SUM(IF(image='235C7987796D5B7CEBF56FBDA2BF7815',1,0)) as
235C7987796D5B7CEBF56FBDA2BF7815,
SUM(IF(image='9
I have a query with three subselects, all referencing the same table. I'd like
to be able to combine them into one with aliases.
Here's what I have now:
select letter_codename,
(select greek from letter_otherlanguages where letter ='A') as greek,
(select french from letter_otherlanguages where
Say I have the following data:
+---+
| title
|
+---+
| ...And justice fo
Hi,
I have a table of events like this:
Evtuid
Evtname
Startdate
Stopdate
Repeats enum('true', 'false')
Monday enum('true', 'false')
Tuesday enum('true', 'false')
Wednesday enum('true', 'false')
Thursday enum('true', 'false')
Friday enum('true', 'false')
Satday enum('true', 'false')
Sunday enum('
Hi,
I'm having trouble wrapping my head around this problem. I have a list
of events for multiple computers. What I want to get is a summary of
the top 3 most common errors for each computer. So I get a result like
this:
Computername event numb_times
Comp1 l
_stamp),
> KEY day_of_week (day_of_week),
> KEY day_in_month (day_in_month),
> KEY day_in_month_R (day_in_month_R),
> KEY month_day (month_day),
> KEY month_day_R (month_day_R),
> KEY month (month),
> KEY year_day (year_day),
> KEY year_day_R (year_day_R),
> KEY week_number (week
Hi,
I'm looking for a "best practices" way of creating tables to store both
one time and regularly repeating events. These are classes, so for the
most part the have a regularly recurring time, but we do have some one
off events. For example, let's say the following:
Class-A Mon,Wed,Fri 8-9 fro
Hi,
I'm doing an event project and some of the events will be reccuring. For
example:
Monday, Wednesday, Friday from 10-11:30 am starting June 1 with no end date
Every third Monday at 3-4 pm starting July 1 and ending January 1 (last event
is third Monday in December)
Every other Friday start
