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 Ge
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 al
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
> d
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 id
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
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
I
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
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 ser
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 r
