Re: Help saving MySQL

2009-12-12 Thread Mihamina Rakotomandimby
> Ryan Chan : > On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman > wrote: > > I hope the only reason this thread  is so quiet is because we are > > all busy notifying our friends.  There are a hell of a lot more > > users invested in MySQL than those who read this list.  Spread the > > word! > >

Re: Help saving MySQL

2009-12-12 Thread Ryan Chan
On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote: > I hope the only reason this thread  is so quiet is because we are all > busy notifying our friends.  There are a hell of a lot more users > invested in MySQL than those who read this list.  Spread the word! > Let's stand up today to face t

Re: Help saving MySQL

2009-12-12 Thread Michael Dykman
I hope the only reason this thread is so quiet is because we are all busy notifying our friends. There are a hell of a lot more users invested in MySQL than those who read this list. Spread the word! Monty is not asking us to help him: he is asking you to help yourselves. MySQL has never been

RE: Multiple joins from same table?

2009-12-12 Thread Terry Van de Velde
Shawn, Thanks for the info, it does help indeed. I had also replied back to Gary to thank him as well, but I don't think that it made it to the list... so to Gary, thanks as well. Regards, Terry Terry Van de Velde Email: bya...@rogers.com Phone: (519) 685-0295 Cell:  (519) 619-0987 -Origi

Help saving MySQL

2009-12-12 Thread Michael Widenius
Subject: Help saving MySQL from Oracle! I, Michael "Monty" Widenius, the creator of MySQL, is asking you urgently to help save MySQL from Oracle's clutches. Without your immediate help Oracle might get to own MySQL any day now. By writing to the European Commission (EC) you can support this caus

Re: Multiple joins from same table?

2009-12-12 Thread Shawn Green
Terry Van de Velde wrote: Good Day, I am attempting to do something new (to me) with MySQL. I am looking to have my query return with the value in the visitor and home columns replaced with the corresponding team name from the teams table. schedule.visitor and schedule.home are essentially fore

Re: Join on a where clause.

2009-12-12 Thread Shawn Green
Hello Paul, Paul Halliday wrote: I have 2 tables: 1) Event Data 2) Mappings The query should return something like this: Hits IP Country Code 20213.136.52.29 SE I am trying this: SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip), mappings.cc

Re: inserting sets of data

2009-12-12 Thread Victor Subervi
On Sat, Dec 12, 2009 at 10:58 AM, David Giragosian wrote: > On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi > wrote: > >> Hi; >> I have a column defined as a set. How do I insert data into that column? >> Please give me an example. >> TIA, >> Victor >> > > > Lots of examples here: > http://dev.my

Re: inserting sets of data

2009-12-12 Thread David Giragosian
On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi wrote: > Hi; > I have a column defined as a set. How do I insert data into that column? > Please give me an example. > TIA, > Victor > Lots of examples here: http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html David -- There is

inserting sets of data

2009-12-12 Thread Victor Subervi
Hi; I have a column defined as a set. How do I insert data into that column? Please give me an example. TIA, Victor