mySQL vs. NoSQL

2010-10-07 Thread Daevid Vincent
You guys hear talk about NoSQL and here's a good article on the topic especially as to how it pertains to mySQL... http://www.linuxjournal.com/article/10770 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Re: my.ini

2010-10-07 Thread Elim PDT
Thanks a lot Andrew. - Original Message - From: To: ; Sent: Thursday, October 07, 2010 3:07 AM Subject: RE: my.ini Open you're my.ini and correct the values as stated in the event viewer Check the online documentation for the keys and values to set. http://dev.mysql.com/doc/refman/

Fwd: Design advice

2010-10-07 Thread Tompkins Neil
Wonder if anyone can help me ? -- Forwarded message -- From: Tompkins Neil Date: Tue, Oct 5, 2010 at 10:07 AM Subject: Design advice To: "[MySQL]" Hi I have a number of tables of which I use to compute totals. For example I have table : players_master rec_id players_name tea

Query working on 5.1.43 and not 5.0.77

2010-10-07 Thread Tompkins Neil
Hi, My hosting company are only running MySQL version 5.0.77 and at this current time are not planning on upgrading to at least my required version of 5.1.43. My query in which I have some problems is shown below : SELECT teams_id AS teams_id ,SUM(rating) AS total_team_rating FROM (SELECT teams

RE: my.ini

2010-10-07 Thread andrew.2.moore
Open you're my.ini and correct the values as stated in the event viewer Check the online documentation for the keys and values to set. http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html Regards -Original Message- From: ext Elim PDT [mailto:e...@pdtnetworks.net] Sent: 07

Re: Constructing query to display item count based on increments of time

2010-10-07 Thread Johan De Meersman
On Wed, Oct 6, 2010 at 11:15 PM, Hank wrote: > Ok, I can see that. > Oh, I wasn't implying that mine was necessarily better - I didn't even think of doing it that way. I suggested a benchmark because different fuctions might have different execution speeds. Now actually thinking about this, I've

Re: update and times

2010-10-07 Thread Simcha Younger
On Wed, 06 Oct 2010 17:48:55 -0400 kalin m wrote: > > > Simcha Younger wrote: > >> executing this query didn't update the record. > >> > >> why? > >> > > The two values you have here are equal: > > sample data : 12862162510269684 > > query: where unix_time < 1286216251026