Thanks for the tip Mike. -Kevin ----- Original Message ----- From: "Mike Eheler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 10:49 AM Subject: Re: [PHP] phpMyAdmin
> I've always found it's good to set numeric primary keys to UNSIGNED. > Gives you a larger range, and it's not very likely those numbers are > ever going to be negative. > > Also, there is absolutely no need to check Index or Unique when you have > selected Primary, as Primary implies both (hence why in newer versions, > Primary/Index/Unique are radio buttons). Lastly, unless you expect to > have a rediculous amount of records, an INT is more that sufficient > (giving you a maximum record count of 4,294,967,295). Also, PHP's > mysql_insert_id() doesn't support BIGINT data types. > > So, the more optimised version of the keyfield would be: > > > Field: keynum > > Type: INT > > Length/Values: (blank) > > Attributes: UNSIGNED > > Null: NOT NULL > > Default: (blank) > > Extra: AUTO_INCREMENT > > Primary: SELECTED > > Index: UN-SELECTED > > Unique: UN-SELECTED > > Mike > > Kevin Stone wrote: > > Could be something like.. > > > > Field: keynum > > Type: BIGINT > > Length/Values: (blank) > > Attributes: (blank) > > Null: NOT NULL > > Default: (blank) > > Extra: AUTO_INCREMENT > > Primary: CHECKED > > Index: CHECKED > > Unique: CHECKED > > > > Field: username > > Type: VARCHAR > > Length/Values: 20 > > Attributes: (blank) > > Null: NOT NULL > > Default: (blank) > > Extra: (blank) > > Primary: UNCHECKED > > Index: UNCHECKED > > Unique: UNCHECKED > > > > Field: password > > Type: VARCHAR > > Length/Values: 20 > > Attributes: (blank) > > Null: NOT NULL > > Default: (blank) > > Extra: (blank) > > Primary: UNCHECKED > > Index: UNCHECKED > > Unique: UNCHECKED > > > > Note I prefer to use VARCHAR instead of PASSWORD becuase I am more > > comfortable checking the database contents in PHP rather than SQL. But you > > can do a PASSWORD field then in your query statment use the SQL funciton > > PASSWORD($pwd) to encrypt the string. Either way, for security, it is > > imparative that you encrypt it. > > > > The field 'keynum' is just a standard thing that I do. It's set up to > > auto_increment so you always have a unique key to delete and update records > > on. For more information view the SQL documentation on www.mysql.com. > > > > Hope this helps! > > -Kevin > > > > ----- Original Message ----- > > From: "Rodrigo" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, May 03, 2002 10:18 AM > > Subject: [PHP] phpMyAdmin > > > > > > > >>Hi guys, I need some help using the phpMyAdmin, I'm trying to create a > >>table with three fields, one for the indexing of the database, the > >>second for the logins and the third for the password. > >> > >>I get the following doubts: > >> > >>On the table of the phpMyAdmin there are the following fields: > >> > >>A field for the name of the field. > >>A field for the kind of information that will be stored in the field > >>(TINYINT,DOUBLE,TEXT...) > >>A field for the size of the field. > >>A field for the atributes of the field (BINARY, UNSIGNED, UNSIGNED ZERO > >>FILL) > >>A field for the null option (NULL, NOT NULL). > >>A field for an information that I don't know... > >>A field for the Extra(AUTO_INCREMENT). > >>A selectable field named primary(check it or not). > >>A selectable field named index(check it or not). > >>A selectable field named unique(check it or not). > >>A selectable field named Fulltext(Check it or not). > >> > >>The information that I would need would be what are the configurations > >>that I have to put in each of these fields. > >>And also I would need to know a php script to access the fields, and > >>write to new fields. > >> > >>Thanx, Rodrigo > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php