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

Re: inserting sets of data

2009-12-12 Thread David Giragosian
On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi victorsube...@gmail.comwrote: 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

Re: inserting sets of data

2009-12-12 Thread Victor Subervi
On Sat, Dec 12, 2009 at 10:58 AM, David Giragosian dgiragos...@gmail.comwrote: On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi victorsube...@gmail.comwrote: 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

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: 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

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 cause

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

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: Help saving MySQL

2009-12-12 Thread Ryan Chan
On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman mdyk...@gmail.com 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

Re: Help saving MySQL

2009-12-12 Thread Mihamina Rakotomandimby
Ryan Chan ryanchan...@gmail.com : On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman mdyk...@gmail.com 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