flow control in mysql

2001-04-22 Thread Kevin Xin Lin 

Hi,

Does mysql query support iteration? Can I write loop logic in a mysql
qurey? thanks.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Date,time,datetime type

2001-04-18 Thread Kevin Xin Lin 

Hi there,

If I need compare 2 fields of DATE and TIME  to a field of
TIMESTAMP/DATETIME in my query,
what am I supposed to do? Is there a function to get DATE/TIME part from

a DATETIME field, or combine DATE and TIME to a DATETIME type?

thanks.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to get average value for top n records?

2001-04-15 Thread Kevin Xin Lin 

Hi, if I have a table with only one field A like this:

record#1: 2
record#2: 3
record#3: 2
record#4: 4
record#5: 6
record#6: 8

How to write a sql statement to retrieve the average value of field A
for the last 3 records?

Did I make sense here? Thanks for help.





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

performance question

2001-04-06 Thread Kevin Xin Lin 

I'm very new to mysql. I wonder how good is mysql, and comparing it to
MS Access. I know mysql is supposed to be way faster than Access,
however, to my surprise, it's not necessary the case.

I have a table with 700K records. I issued these 2 queries:

Access:
select top 30 * from rawdata
mysql:
select * from rawdata limit 1,30

It seemed to me that Access return the result set faster than mysql (at
least 1.5 secs difference). What did I do wrong?

Thanks in advance.

Kevin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

import - date format

2001-04-05 Thread Kevin Xin Lin 

Hi there,

I have many files need import into mysql database. Unfortunately, the
date format in my csv file is mm/dd/, so is there a wordaround that
I don't need write another script to convert all my files?

Thanks.

Kevin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

free admin/client gui for win32

2001-04-05 Thread Kevin Xin Lin 

Can any one share with me a good free admin/client GUI for win32?

Thanks.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php