Hi list readers,
I'm experiencing some strange problems with MySQL 4.1.14. I have a script that
is run as a cronjob in five minute intervals. The script initiates a database
connection and executes certain SQL commands. Sometimes, but not regularly, the
server gives access denied error. If I
Ed Kasky wrote:
Running MySql 4.1.14 on RedHat 7.2
I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems
using the mysql client.
# /usr/local/mysql/bin/mysql -h localhost -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34 to
At 10:15 AM Saturday, 8/27/2005, Kemin Zhou wrote -=
Ed Kasky wrote:
Running MySql 4.1.14 on RedHat 7.2
I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems
using the mysql client.
# /usr/local/mysql/bin/mysql -h localhost -u root
Welcome to the MySQL monitor. Commands
Using mysql with php I have a database that has a unique value for the user id.
when people get delete off the list I want the unique numbers to compact down
so.
user id 1
user id 4
user id 5
user id 7
user id 9
user id 10
becomes
user id 1
user id 2
user id 3
user id 4
user id 5
user id 6
On Sat, 27 Aug 2005 19:43:57 +0100, [EMAIL PROTECTED] said:
Using mysql with php I have a database that has a unique value for the
user id. when people get delete off the list I want the unique numbers to
compact down so.
user id 1
user id 4
user id 5
user id 7
user id 9
user id 10
leegold wrote:
On Sat, 27 Aug 2005 19:43:57 +0100, [EMAIL PROTECTED] said:
Using mysql with php I have a database that has a unique value for the
user id. when people get delete off the list I want the unique numbers to
compact down so.
user id 1
user id 4
user id 5
user id 7
user id 9
user
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
Ville Mattila [EMAIL PROTECTED] wrote:
Hi list readers,
I'm experiencing some strange problems with MySQL 4.1.14. I have a script
that is run as a cronjob in five minute intervals. The script initiates a
Ross
Using mysql with php I have a database that has a unique value
for the user id. when people get delete off the list I want the
unique
numbers to compact down so.
Generally it's a really bad idea to edit primary keys. If you
absolutely must compact the key values, you can do it by
Ross
Apologies for the typo, the snippet for finding the highest id should say
SELECT id FROM tablename ORDER BY id DESC LIMIT 1;
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.16/83 - Release Date: 8/26/2005
--
MySQL