RE: Calculate elapsed time between 2 time/dates

Hi, I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) between 2 time dates. Can't seem to find any of these functions in the Mysql manual. The nearest was Period_diff() which is calculating months elapsed. Thanks Nyon --- Outgoing mail is certified Virus Free. Checked by AVG anti

RE: MySQL security settings

I installed MySQL on Windows NT. Currently, I login in using annoyomous user. I can't seem to login in as root user. The syntax is : mysql -u root -p xxx It's seems funny as I can see the root password in the MySQL database -- user table. Any help ? Nyon

Install mysql-nt or mysql-max-nt

Hi, I am installing MySQL in Windows 2000 Advanced Server. However, the installation comes with two files for NT, namely mysql-nt.exe and mysql-max-nt.exe. Which one I should use ? Nyon

Add password to a existing database/table

measure. The hostname and password will be keep in a *.inc file outside the web root directory. Thanks Nyon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com