This is not a problem. Please help me to understand: why would you WANT the primary key field to be updated?
I ask, because if the fields of other tables refer to the primary keys of phpSP_users and then the primary key of phpSP_users was updated due to deletions; the result would be that those other tables' fields no longer "pointed to" the phpSP_users record they are supposed to. Bottom line: in a relational database system, sequential keys DO NOT MATTER. -----Original Message----- From: Byron Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: Non-Sequential Primary Key Index I have the following table: CREATE TABLE phpSP_users ( primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, user varchar(50) NOT NULL, password varchar(30) NOT NULL, userlevel smallint(3) DEFAULT '0' NOT NULL, service_name varchar(50) DEFAULT 'A Childs Place', full_name varchar(50), visit_count smallint(5) unsigned DEFAULT '0', last_visit date DEFAULT '0000-00-00', active_user varchar(5) DEFAULT 'TRUE', teachers_child varchar(5) DEFAULT 'FALSE', email varchar(50), childs_name_1 varchar(50), childs_name_2 varchar(50), phone_number varchar(30), PRIMARY KEY (primary_key), KEY user (user), KEY primary_key (primary_key) ); My host has phpMyAdmin 2.0.1 and MySQL 3.22.21. When I delete rows from the database in phpMyAdmin, it does not update the Primary_Key field, so the numbers are NOT sequential. Would this pose a problem? I've tried to run "myisamchk", "CHECK TABLE" through phpMyAdmin but it doesn't work. It gives me a syntax error all the time. Check this out: http://www.phpwizard.net/phorum/read.php?f=1&i=3136&t=3103 I was thinking perhaps that I might have another type of table becasue of my MySQl version, I ran ALTER TABLE to change it to a MYISAM table. That didn't give me any errors but I still could not run CHECK TABLE. I tried running the "isamchk" (old command) no luck. I do not have remote access to the database. Need some help here Thanks a big bunch Also--- I am looking for a good way to edit the database offline, but I havn't seen anything really streamlined. I want to take the SQL files generated, edit the database and upload the changes. What program is good for this? Is there a good tutorial on how to do this? __________ Byron Scott --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
