flow control in mysql

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)

Date,time,datetime type

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.

how to get average value for top n records?

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

performance question

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 mysq

free admin/client gui for win32

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 thi

import - date format

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