i used MySQL bible and mysql's help file (its more like a book than a help file)

i know this is seriously late

so you want to store the mp3's in the database? why not just use the database to link to them so
user interface (html with serverside scripting) - database - files...

you will need to have the database servers ip or dns name

mysqldump --opt databasename > path_and_filname.sql

or from your cmd prompt

mysqldump -h hostserver -u username -ppasword --opt...

SHOW PROCESSLIST;

then

KILL ???

??? being the id value for the process

UPDATE `adds` SET `client` = 'client1',`TOTALCOST` = 'totalcost' WHERE `ID` =9710


INSERT INTO `adds` ( `ID` , `client` , `colour`)
VALUES (
NULL , 'sda', 'ads');


try like that

PHPmyAdmin has such a feature unfortunately (as said) you need to run it on a websever.

MySQL Query Browser from MySQL website helps ALOT to get mysql specific SQL (access and MySQL not quite the same) at the same time you can test a sql statement. i started by creating my tables and...

ARE YOU TRYING TO GET THE TOTAL AMOUNT OF RECORDS THAT ARE GREATER THAN 1 AND LESS THAN 27. is that all? I don't quite understand what you want out of the equation.