Hi Buff, Try under the optimization section. Though keep in mind the impact on speed shouldn't be that great.. By the way.. in an ideal design your primary key will be an integer ;-)
Buff Smith wrote: > > Colin, > > Where can I read about the impact of having Primary Keys as VARCHAR? This > entails an 8 times overhead in Sybase, Oracle, and Microsoft for changing > PK values. It must rebuild the index versus and "update-in-place." > > Buff Smith, Maestro > THE BLUES BUFFET BAND > 310 280-3593 > http://BluesBuffetBand.com > (AKA) [EMAIL PROTECTED] > > -----Original Message----- > From: Colin Faber [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, May 18, 2002 3:46 PM > To: [EMAIL PROTECTED] > Cc: '[EMAIL PROTECTED]' > Subject: Re: apparent bug > > Hi, > > this is a feature. see > http://www.mysqldeveloper.com/manual/index.pcgi?section=Silent_column_ch > anges > ;-) > > Buff Smith wrote: > > > > To Whom It May Concern: > > > > I have reported the following symptoms in UNIX using 'mysqlbug' character > > mode utility. I am including the text of that problem statement with > this > > email. Additionally, I am attaching several sample DDL input files, and > > the results of SHOW COLUMNS FROM <table name> output. > > > > Voila, the mysqlbug problem text: > > > > ************************************************************************ > > ******************************************************* > > SEND-PR: -*- send-pr -*- > > SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as > > SEND-PR: will all comments (text enclosed in `<' and `>'). > > SEND-PR: > > From: buff > > To: [EMAIL PROTECTED] > > Subject: DDL CREATE TABLE data format CHAR(x) compiles as VARCHAR(x) > > > > Description: > > My DDL files for CREATE TABLE statements contain no VARCHAR(x) > data > > formats. However, when compiling all DDL for a given database. For some > > reason invisible to me, some of the columns whose data format is CHAR(x) > > end up being created as VARCHAR(x). The set of columns that mutate in > > this fashion is consistent, i.e., the same set of columns always get this > > error. However, the rime or reason for this set seems to be > happenstance. > > > > That is: For a given dB name with a parallel set of DDL the same columns > > mutate to VARCHAR. In other words: I use DDL set A with dB name 1, DDL > > set B with dB name 2, etc., etc. > > NOTE: pair A1, B2, etc get consistent within pair, but consistently > > different between pair sets of VARCHAR columns. > > > > The string /VARCHAR/ cannot be found via grep in any of my DDL > scripts. I > > can email or FTP a DDL script. > > How-To-Repeat: > > I will email or FTP a set of DDL scripts > > Fix: > > NONE > > > > Submitter-Id: [EMAIL PROTECTED] > > Originator: Buff > > Organization: cynchrony.com hosted by interland.com > > MySQL A.B's customer is Interland > > MySQL support: interland.com says -- none > > Synopsis: CHAR(X) mutates in DDL compile varchar(x) > > Severity: critical > > Priority: medium > > Category: mysql > > Class: sw-bug > > Release: mysql-3.22.32 (Source distribution) > > > > Environment: FreeBSD cynchrony.com 4.1.1-STABLE FreeBSD 4.1.1-STABLE #0: > > Tue Aug 21 22:35:59i GMT 2001 > > root@osbuilder:/usr/obj/usr/src/sys/SERVER i386 > > > > MySql Version: > > +-----------+ > > | version() | > > +-----------+ > > | 3.22.32 | > > +-----------+ > > ************************************************************************ > > ************************************************* > > end of mysqlbug problem statement text > > > > In preparing data for this email I noticed that it seems to happen for > > columns added after a certain period of time. Originally, the > > Question_Asked_Quantitative table did not have the Question_Subscale_Name > > column. Generation number 2 DDL version 09 of the trimergence_main > > database did not have the column, whereas generation number 3 DDL > version > > 13 of the trimergence_main database added that and other columns. > > > > The current version of mysql is listed in the mysqlbug problem statement > > text, above > > I do not know which version mysql was when generation 2 of the database > was > > created. > > > > attachments follow --> > > > > generation 09 show cols =========================== > > Field Type Null Key Default Extra > > Questionnaire_ID int(11) PRI 0 > > Question_Number int(11) PRI 0 > > Question_Subscale_Name varchar(32) PRI > > Question_Text text NULL > > > > Generation 09 DDL ================================= > > use trimergence_main2; > > > > CREATE TABLE Customer_Authentication ( > > Customer_ID CHAR(30) NOT NULL, > > Customer_Name CHAR(128) NOT NULL, > > Company_SignUp_date DATE NOT NULL, > > Company_Expire_Date DATE NOT NULL, > > Customer_Validation_flag CHAR(1) NOT NULL, > > Contact_Person CHAR(128) NOT NULL, > > Contact_email CHAR(128) NOT NULL, > > Customer_address_street CHAR(128), > > Customer_address_city CHAR(64), > > Customer_address_state_cd CHAR(2), > > Contact_area_code CHAR(3) NOT NULL, > > Contact_phone CHAR(8) NOT NULL, > > Customer_address_zipcode CHAR(10), > > Customer_URL_name CHAR(128), > > PRIMARY KEY (Customer_ID) > > ); > > > > CREATE UNIQUE INDEX XPKCustomer_Authentication ON Customer_Authentication > > ( > > Customer_ID ASC > > ); > > > > CREATE TABLE Question_Asked_Qualitative ( > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Asked_Text TEXT NOT NULL, > > Question_Answer_Text TEXT NOT NULL, > > PRIMARY KEY (Questionnaire_ID, Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Asked_Qualitative ON > > Question_Asked_Qualitative > > ( > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Question_Asked_Quantitative ( > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Text TEXT NOT NULL, > > PRIMARY KEY (Questionnaire_ID, Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Asked_Quantitative ON > > Question_Asked_Quantitative > > ( > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Question_Qualitative_Answer ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Question_number INTEGER NOT NULL, > > Question_Answer_Text TEXT NOT NULL, > > Question_Answered_Flag CHAR(1) NOT NULL, > > Question_Answer_Merged_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID, > > Question_number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Qualitative_Answer ON > > Question_Qualitative_Answer > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC, > > Question_number ASC > > ); > > > > CREATE TABLE Question_Quantitative_Answer ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Answer_Score TINYINT NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID, > > Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Quantitative_Answer ON > > Question_Quantitative_Answer > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Questionnaire_Form ( > > Questionnaire_ID INTEGER NOT NULL, > > Questionnaire_Name_Brief CHAR(16) NOT NULL, > > Questionnaire_Name_Long CHAR(128) NOT NULL, > > Question_Count SMALLINT NOT NULL, > > Question_Fee_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Questionnaire_ID) > > ); > > > > CREATE UNIQUE INDEX XPKQuestionnaire_Form ON Questionnaire_Form > > ( > > Questionnaire_ID ASC > > ); > > > > CREATE TABLE Questionnaire_Status ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Questionnaire_Status SMALLINT NOT NULL, > > Quantitative_Sum SMALLINT NOT NULL, > > Email_Sent_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID) > > ); > > > > CREATE UNIQUE INDEX XPKQuestionnaire_Status ON Questionnaire_Status > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC > > ); > > > > CREATE TABLE User_Authentication ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Password CHAR(16) NOT NULL, > > User_Access_Level_Code TINYINT NOT NULL, > > User_SignUp_Date DATE NOT NULL, > > Password_Reminder CHAR(64) NOT NULL, > > User_Expire_Date DATE NOT NULL, > > Login_User_Name CHAR(60) NOT NULL, > > User_Validated_Flag CHAR(1) NOT NULL, > > Email_Address CHAR(128) NOT NULL, > > Phone_area_code CHAR(3) NOT NULL, > > Phone_number CHAR(8) NOT NULL, > > Questionnaire_Count SMALLINT NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID) > > ); > > > > CREATE UNIQUE INDEX XPKUser_Authentication ON User_Authentication > > ( > > Customer_ID ASC, > > Login_ID ASC > > ); > > > > ==================================================== > > generation 13 show cols > > > > use trimergence_main2; > > > > CREATE TABLE Customer_Authentication ( > > Customer_ID CHAR(30) NOT NULL, > > Customer_Name CHAR(128) NOT NULL, > > Company_SignUp_date DATE NOT NULL, > > Company_Expire_Date DATE NOT NULL, > > Customer_Validation_flag CHAR(1) NOT NULL, > > Contact_Person CHAR(128) NOT NULL, > > Contact_email CHAR(128) NOT NULL, > > Customer_address_street CHAR(128), > > Customer_address_city CHAR(64), > > Customer_address_state_cd CHAR(2), > > Contact_area_code CHAR(3) NOT NULL, > > Contact_phone CHAR(8) NOT NULL, > > Customer_address_zipcode CHAR(10), > > Customer_URL_name CHAR(128), > > PRIMARY KEY (Customer_ID) > > ); > > > > CREATE UNIQUE INDEX XPKCustomer_Authentication ON Customer_Authentication > > ( > > Customer_ID ASC > > ); > > > > CREATE TABLE Question_Asked_Qualitative ( > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Asked_Text TEXT NOT NULL, > > Question_Answer_Text TEXT NOT NULL, > > PRIMARY KEY (Questionnaire_ID, Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Asked_Qualitative ON > > Question_Asked_Qualitative > > ( > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Question_Asked_Quantitative ( > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Text TEXT NOT NULL, > > PRIMARY KEY (Questionnaire_ID, Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Asked_Quantitative ON > > Question_Asked_Quantitative > > ( > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Question_Qualitative_Answer ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Question_number INTEGER NOT NULL, > > Question_Answer_Text TEXT NOT NULL, > > Question_Answered_Flag CHAR(1) NOT NULL, > > Question_Answer_Merged_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID, > > Question_number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Qualitative_Answer ON > > Question_Qualitative_Answer > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC, > > Question_number ASC > > ); > > > > CREATE TABLE Question_Quantitative_Answer ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Answer_Score TINYINT NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID, > > Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Quantitative_Answer ON > > Question_Quantitative_Answer > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Questionnaire_Form ( > > Questionnaire_ID INTEGER NOT NULL, > > Questionnaire_Name_Brief CHAR(16) NOT NULL, > > Questionnaire_Name_Long CHAR(128) NOT NULL, > > Question_Count SMALLINT NOT NULL, > > Question_Fee_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Questionnaire_ID) > > ); > > > > CREATE UNIQUE INDEX XPKQuestionnaire_Form ON Questionnaire_Form > > ( > > Questionnaire_ID ASC > > ); > > > > CREATE TABLE Questionnaire_Status ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Questionnaire_Status SMALLINT NOT NULL, > > Quantitative_Sum SMALLINT NOT NULL, > > Email_Sent_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID) > > ); > > > > CREATE UNIQUE INDEX XPKQuestionnaire_Status ON Questionnaire_Status > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC > > ); > > > > CREATE TABLE User_Authentication ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Password CHAR(16) NOT NULL, > > User_Access_Level_Code TINYINT NOT NULL, > > User_SignUp_Date DATE NOT NULL, > > Password_Reminder CHAR(64) NOT NULL, > > User_Expire_Date DATE NOT NULL, > > Login_User_Name CHAR(60) NOT NULL, > > User_Validated_Flag CHAR(1) NOT NULL, > > Email_Address CHAR(128) NOT NULL, > > Phone_area_code CHAR(3) NOT NULL, > > Phone_number CHAR(8) NOT NULL, > > Questionnaire_Count SMALLINT NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID) > > ); > > > > CREATE UNIQUE INDEX XPKUser_Authentication ON User_Authentication > > ( > > Customer_ID ASC, > > Login_ID ASC > > ); > > > > ================================================ > > generation 13 DDL > > USE trimergence_main4; > > > > CREATE TABLE Customer_Authentication ( > > Customer_ID CHAR(30) NOT NULL, > > Customer_Name CHAR(128) NOT NULL, > > Customer_SignUp_date DATE NOT NULL, > > Customer_Expire_Date DATE NOT NULL, > > Customer_Validation_flag CHAR(1) NOT NULL, > > Customer_Contact_Name CHAR(128) NOT NULL, > > Customer_Contact_Email CHAR(128) NOT NULL, > > Customer_address_street CHAR(128), > > Customer_address_city CHAR(64), > > Customer_Address_State_Code CHAR(2), > > Customer_Address_Zipcode CHAR(10), > > Customer_Area_Code CHAR(3) NOT NULL, > > Customer_Phone_Number CHAR(8) NOT NULL, > > Customer_FAX_Number CHAR(12), > > Customer_Country_Code CHAR(3), > > Customer_URL_Name CHAR(128), > > PRIMARY KEY (Customer_ID) > > ); > > > > CREATE UNIQUE INDEX XPKCustomer_Authentication ON Customer_Authentication > > ( > > Customer_ID ASC > > ); > > > > CREATE TABLE Question_Asked_Qualitative ( > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Asked_Text TEXT NOT NULL, > > Question_Feedback_Text TEXT NOT NULL, > > PRIMARY KEY (Questionnaire_ID, Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Asked_Qualitative ON > > Question_Asked_Qualitative > > ( > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Question_Asked_Quantitative ( > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Subscale_Name CHAR(32) NOT NULL, > > Question_Text TEXT NOT NULL, > > PRIMARY KEY (Questionnaire_ID, Question_Number, > > Question_Subscale_Name) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Asked_Quantitative ON > > Question_Asked_Quantitative > > ( > > Questionnaire_ID ASC, > > Question_Number ASC, > > Question_Subscale_Name ASC > > ); > > > > CREATE TABLE Question_Qualitative_Answer ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Answer_Text TEXT NOT NULL, > > Question_Answered_Flag CHAR(1) NOT NULL, > > Question_Answer_Merged_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID, > > Question_Number) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Qualitative_Answer ON > > Question_Qualitative_Answer > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC, > > Question_Number ASC > > ); > > > > CREATE TABLE Question_Quantitative_Answer ( > > Customer_ID CHAR(30) NOT NULL, > > Question_Subscale_Grouping_Number SMALLINT NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Question_Number INTEGER NOT NULL, > > Question_Subscale_Name CHAR(32) NOT NULL, > > Answer_Score TINYINT NOT NULL, > > PRIMARY KEY (Customer_ID, Question_Subscale_Grouping_Number, > > Login_ID, Questionnaire_ID, Question_Number, > > Question_Subscale_Name) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Quantitative_Answer ON > > Question_Quantitative_Answer > > ( > > Customer_ID ASC, > > Question_Subscale_Grouping_Number ASC, > > Login_ID ASC, > > Questionnaire_ID ASC, > > Question_Number ASC, > > Question_Subscale_Name ASC > > ); > > > > CREATE TABLE Question_Quantitative_Subscale ( > > Question_Subscale_Grouping_Number SMALLINT NOT NULL, > > Question_Subscale_Name CHAR(32) NOT NULL, > > Range_Number SMALLINT NOT NULL, > > Range_Value_Low_Number SMALLINT NOT NULL, > > Range_Value_High_Number SMALLINT NOT NULL, > > Question_Subscale_Description TEXT NOT NULL, > > PRIMARY KEY (Question_Subscale_Grouping_Number, > > Question_Subscale_Name) > > ); > > > > CREATE UNIQUE INDEX XPKQuestion_Quantitative_Subscale ON > > Question_Quantitative_Subscale > > ( > > Question_Subscale_Grouping_Number ASC, > > Question_Subscale_Name ASC > > ); > > > > CREATE TABLE Questionnaire_Form ( > > Questionnaire_ID INTEGER NOT NULL, > > Questionnaire_Name_Brief CHAR(16) NOT NULL, > > Questionnaire_Name_Long CHAR(128) NOT NULL, > > Question_Count SMALLINT NOT NULL, > > Question_Fee_Flag CHAR(1) NOT NULL, > > Question_Mandatory_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Questionnaire_ID) > > ); > > > > CREATE UNIQUE INDEX XPKQuestionnaire_Form ON Questionnaire_Form > > ( > > Questionnaire_ID ASC > > ); > > > > CREATE TABLE Questionnaire_Status ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Questionnaire_ID INTEGER NOT NULL, > > Questionnaire_Status SMALLINT NOT NULL, > > Quantitative_Sum SMALLINT NOT NULL, > > Email_Sent_Flag CHAR(1) NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID, Questionnaire_ID) > > ); > > > > CREATE UNIQUE INDEX XPKQuestionnaire_Status ON Questionnaire_Status > > ( > > Customer_ID ASC, > > Login_ID ASC, > > Questionnaire_ID ASC > > ); > > > > CREATE TABLE User_Authentication ( > > Customer_ID CHAR(30) NOT NULL, > > Login_ID CHAR(30) NOT NULL, > > Password CHAR(16) NOT NULL, > > User_Access_Level_Code TINYINT NOT NULL, > > User_SignUp_Date DATE NOT NULL, > > Password_Reminder CHAR(64) NOT NULL, > > User_Expire_Date DATE NOT NULL, > > User_Full_Name CHAR(60) NOT NULL, > > User_Validated_Flag CHAR(1) NOT NULL, > > Email CHAR(128) NOT NULL, > > Phone_Area_Code CHAR(3) NOT NULL, > > Phone_Number CHAR(8) NOT NULL, > > Questionnaire_Count SMALLINT NOT NULL, > > PRIMARY KEY (Customer_ID, Login_ID) > > ); > > > > CREATE UNIQUE INDEX XPKUser_Authentication ON User_Authentication > > ( > > Customer_ID ASC, > > Login_ID ASC > > ); > > > > CREATE TABLE Validation_Codes_Country ( > > Country_Code CHAR(3) NOT NULL, > > Country_Name CHAR(128) NOT NULL, > > PRIMARY KEY (Country_Code) > > ); > > > > CREATE UNIQUE INDEX XPKValidation_Codes_Country ON > Validation_Codes_Country > > ( > > Country_Code ASC > > ); > > > > CREATE TABLE Validation_Codes_State ( > > State_Code CHAR(2) NOT NULL, > > State_Name CHAR(128) NOT NULL, > > PRIMARY KEY (State_Code) > > ); > > > > CREATE UNIQUE INDEX XPKValidation_Codes_State ON Validation_Codes_State > > ( > > State_Code ASC > > ); > > > > Buff Smith, Project Manager > > Trimergence Web Site Project > > Cynchron.Com a Customer of Interland.Com the hosting ISP. > > 310 280-3593 > > http://www.trimergence.com/ > > (AKA) [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > 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 > > -- > Colin Faber > (303) 736-5160 > fpsn.net, Inc. > > --------------------------------------------------------------------- > 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 -- Colin Faber (303) 736-5160 fpsn.net, Inc. --------------------------------------------------------------------- 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