Re: How to use Auto Increment

2002-09-18 Thread Neil Mansilla
(null,'Rajesh'); If these were the first two records, the two rows would look like this: 1 | Neil 2 | Rajesh Regards, Neil Mansilla whatUseek.com - Before posting, please check: http://www.mysql.com/manual.php

Re: Forgot Mysql-Root Password

2002-09-18 Thread Neil Mansilla
ql directory/files to "mysql"; OR, use the "nobody" user (a common replacement) mysqld --skip-grant-tables --user=nobody Regards, Neil Mansilla whatUseek.com - Before posting, please check: http://www.mysql

Re: MySQL Table alteration question

2002-08-21 Thread Neil Mansilla
ay I strongly suggest that you try this on a phantom table first, before you perform this on a production table? I did perform these successfully on my end; however, I can't stress how important it is that you know for sure it works on your end first. Regards, Neil Mansilla whatUseek.com ---

Re: Keys, Wheres, and Order bys

2002-08-21 Thread Neil Mansilla
t second quote, your ORDER BY will not use the key on field3 for a speedy order. Regards, Neil Mansilla whatUseek.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Exact word search

2002-08-21 Thread Neil Mansilla
d this online, and so far it appears to work -- if anyone could expound on the :<: and :>: that would be swell: WHERE $fields REGEXP '[[:<:]]$keyword[[:>:]]' Regards, Neil Mansilla whatUseek.com ---

Re: calculating date difference in days

2002-08-20 Thread Neil Mansilla
substitute 2002-11-12 with something more meaningful, such as your job-deadline date. Regards, Neil Mansilla whatUseek.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Status question about Mysql

2002-08-20 Thread Neil Mansilla
zing MySQL" Presentation Slides Learn what each of the --set-variable settings does in your my.cnf -- don't get too ambitious with your limits either, because that can cause excessive memory and CPU usage. Neil Mansilla whatUseek.com -