Programming Forums - View Single Post - mysql

programmingnoob · Aug 21st, 2007, 7:45 PM

how do they work?
so i saw someone posting like...

Create Table login
    (Id int(4) NOT NULL,
    UserName varchar(20) NOT NULL,
    Password varchar(6) NOT NULL,
    securityQuestion varchar(50) NOT NULL,
    SecurityAnswer varchar(50) NOT NULL,
    Primary key (Id));

This person is clearly using numeric key...
but how do they work?
If I need information regarding a certain person's username and password... how is numeric key going to help the query?
any help would be greatly appreciated

Aug 21st, 2007, 7:45 PM	#1
programmingnoob Hobbyist Programmer Join Date: Feb 2006 Posts: 154 Rep Power: 3	mysql - question about numeric key how do they work? so i saw someone posting like... (Toggle Plain Text) Create Table login (Id int(4) NOT NULL, UserName varchar(20) NOT NULL, Password varchar(6) NOT NULL, securityQuestion varchar(50) NOT NULL, SecurityAnswer varchar(50) NOT NULL, Primary key (Id)); Create Table login (Id int(4) NOT NULL, UserName varchar(20) NOT NULL, Password varchar(6) NOT NULL, securityQuestion varchar(50) NOT NULL, SecurityAnswer varchar(50) NOT NULL, Primary key (Id)); This person is clearly using numeric key... but how do they work? If I need information regarding a certain person's username and password... how is numeric key going to help the query? any help would be greatly appreciated