Re: Help with query: Row number / Rank from a query...

Thanks Peter, That looks pretty good to me. I never would have figured that out on my own. Dan T On Jun 1, 2006, at 4:06 PM, Peter Brawley wrote: Dan, I want to get a particular users 'rank' or row number from the query. SELECT 1+COUNT(*) AS Rank FROM results r1 INNER JOIN results r2

Re: measuring query time

Deniz Ersoz wrote: Is there a way to get the time spent in the server for each query? Write it in a log or append it to the result ??? Will what is in the slow query log help? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46

please help me.

my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? And would you like to tell me the difference among these editions? Thanks very much! [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz

can i speak chinese?

我的操作系统是redhat 9.0的。 我想装二进制版本的mysql 5.x 但是我不知道哪个版本更适合我。。 我看了一下，mysql最新的版本，有好几个？ 我把它列在了下面，有哪位兄弟可以告诉我哪个版本适合我吗？ 还有，他们都有什么区别吗？ 谢谢大家了。。 [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gzhttp://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-glibc23.tar.gz

Re: How to get machine independent unique id??

On 6/1/06, Neeraj [EMAIL PROTECTED] wrote: Is there any way to get a unique ids across all databases (by any way) , because records from all the databases are finally get stored on a central database. And the ids of transaction (a record) must remain unique in central database. The easiest

Error message when I run mysqld command to start the server

Hello, I have a problem in strating the server. I get these errors, please help me in this regard error C:\Program Files\EasyPHP1-7\mysql\binmysqld Can't start server: Bind on TCP/IP port: No error 060602 15:46:50 Do you already have

RE: Error message when I run mysqld command to start the server

You might have another mysql server running Stop you running server. Change the port and then try.. -Original Message- From: Swaroop.S [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 3:38 PM To: mysql@lists.mysql.com Subject: Error message when I run mysqld command to start the

RE: How to get machine independent unique id??

Many thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:00 PM To: mysql@lists.mysql.com Subject: Re: How to get machine independent unique id?? Isn't UUID() unique for each system it runs on?? -- Chris Quoting Dan Buettner

Automatically add +1 every 30mins

Hi there. I've posted this up on both this list, and the php list as I'm not sure whether this is something that I'd need to do with the php or mysql. Basically, I am making an add-on to my small website which is a mini online game. Every user will have gold, and every 30mins I'd like their

mysql edition problem

my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? And would you like to tell me the difference among these editions? Thanks very much! [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz

Re: Automatically add +1 every 30mins

At 07:58 AM 6/2/2006, Alex Major wrote: Hi there. I've posted this up on both this list, and the php list as I'm not sure whether this is something that I'd need to do with the php or mysql. Basically, I am making an add-on to my small website which is a mini online game. Every user will have

dbExpress: Application crashs after ApplyUpdates

I'm trying to connect a Delphi application into a MySQL Server using dbExpress, but I'm having some problems. I can insert and delete records without any problems, but when I try to update a record the following happens: - ClientDataSet.ApplyUpdates: the application crashs and the updates are

Re: mysql edition problem

My first choice for easy installation: Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads Server 5.0.22-013.9M Download | Pick a mirror MD5: a61b9aec938ec729652872bc123b7508 Max 5.0.22-02.9MDownload | Pick a mirror MD5:

Re: can i speak chinese?

I dunno, Can you? :) -- Peter M. Groen Open Systems Development Klipperwerf 12 2317 DZ Leiden T : +31-(0)71-5216317 M : +31-(0)6-29563390 E : [EMAIL PROTECTED] Skype : peter_m_groen quote who=yuan edit ÎҵIJÙ×÷ϵͳÊÇredhat 9.0µÄ¡£ ÎÒÏë×°¶þ½øÖÆ°æ±¾µÄmysql 5.x

Re: Automatically add +1 every 30mins

Alex, as Miles noted, this could easily be accomplished with an external cron event. Doesn't have to be written in an external language like PHP or perl, even - could be a self-contained crontab entry a la: 0,30 * * * * /path/to/mysql -u user -psecret database_name -e update table_name set

Re: Automatically add +1 every 30mins

Dan, Did not know about events in MySQL. That's a terrific feature. Miles At 09:44 AM 6/2/2006, Dan Buettner wrote: Alex, as Miles noted, this could easily be accomplished with an external cron event. Doesn't have to be written in an external language like PHP or perl, even - could be a

Help With Insert Statements

Hello, I am working through ProSpring book, in which they are using Postgres. I need to convert the following inserts into Mysql 5. The table 'Test' , 'Customer' work fine, but 'CustomerAddresses' blows up on the delete cascade portion. As I was trying to figure out the error, another

help on SQL JOIN

Hi All, I have this test table +--+--+--+--++--+ | username | key1 | key2 | key3 | method | timer| +--+--+--+--++--+ | nhadie | aaa | bbb | ccc | INVITE | 00:00:10 | | nhadie | aaa | bbb | ccc | ACK|

Re: please help me.

On 6/2/06, yuan edit [EMAIL PROTECTED] wrote: my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? You notices most of those files are .asc and .md5 used to verify the integrity of the archive after

Re: help on SQL JOIN

Nhadie, ...what i want to actually achieve is to get only the time of the first INVITE and then it's corresponding BYE so it should look like this +--+--+--+--+--+--+ | username | t1method | t2method | start| stop | timediff |

Re: Automatically add +1 every 30mins

You probably don't want to do it with events or as a cron job. As it sounds from your description the amount of gold is a function of time, perhaps time since they started playing or joined the game. Thus, instead of updating every 30 minutes, when you are selecting the current amount

increasing the search speed

Hi, I have the following table: CREATE TABLE `z` ( `hash` varchar(16) NOT NULL default '', `title` varchar(255) NOT NULL default '', `body` text NOT NULL, FULLTEXT KEY `title` (`title`,`body`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 I have tried the following query: select

Uninstall old version

I was able to install the mysql 5.0 on my machine. But it Looks like there is a older version of mysql that was installed. When I run this command: mysql --version mysql Ver 14.7 Distrib 4.1.13a, for apple-darwin8.0 Now I need to remove this version because when I Type the command mysql to

Re: Uninstall old version

Hello - Yes, looks you've got two versions installed. One is in your PATH (where UNIX looks for items by default), and one is not. To remove your old version, execute 'whereis mysql' from your command prompt and you will get the full path to the mysql version it knows about and is running

Re: help with storing a large binary number as bigint

Hi Byron, This should be a relatively simple question but after looking through the manual for a while I didn't see how to do it. I am working in php and need to store a large binary number in the database. When I try and convert it to a int in php its too big so it converts it to a float and