Date Calculation

Hi List I have two datetime fields on my database. I nedd to return the difference in minutes between them. I tried date_sub, extract(hour_minute from ...) and it does't work Any help will be very apreciated. Thanks Oswaldo Castro -- MySQL General Mailing List For list archives: http

MySQL Error 28

Hi List I got an no space left on device error. Is there a way to drop an index without having MySQL create a temporary table? Can I delete the .myi file directly from the operating system? Thanks in advance Oswaldo Castro

Deleted index file (.MYI)

Hi Everybody I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ? Thanks for any help

Truncated Text data Type

to change the owner and the permissions of the file but nothing works. Could someone help me? Thanks in advance Oswaldo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Drop Index - Error 28

to tell to MySQL to ignore this ? Thanks in advance Oswaldo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

Query to insert not in

at the Table-A and insert that Table-C afterward Is there any other and better (more fast) way to do this? Please any help will be very, very appreciated. Greetings Oswaldo Castro - Before posting, please check: http

Duplicate Keys

Hi List Sorry for the newbie question. Im new to MySQL. I have a table that I don't know how many duplicate records it has, so how do I query and delete all the duplicate (or many multiple) records from a MySQL table ? Thanks in advance Oswaldo Castro

Parameter passing on shell script

substituted and MySQL give an error. Any help will be very appreciated Thanks in advance Oswaldo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com