Daevid Vincent wrote:
So if I had:
CREATE TABLE `rep_table` (
`rep_id` smallint(5) unsigned auto_increment,
`rep_login` varchar(15) NOT NULL default '',
`rep_password` varchar(15) NOT NULL default '',
`rep_fname` varchar(255) NOT NULL default '',
`rep_lname` varchar(255) NOT NULL default '',
- Original Message -
From: "Daevid Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 4:59 PM
Subject: RE: Please tell me why to use KEY (a_id, b_id) rather than KEY
(a_id), KEY (b_id)
> Ah ha!
>
> So if I had:
>
> C
Ah ha!
So if I had:
CREATE TABLE `rep_table` (
`rep_id` smallint(5) unsigned auto_increment,
`rep_login` varchar(15) NOT NULL default '',
`rep_password` varchar(15) NOT NULL default '',
`rep_fname` varchar(255) NOT NULL default '',
`rep_lname` varchar(255) NOT NULL default '',
PRIMARY
In the last episode (Mar 18), Daevid Vincent said:
> I wouldn't say I was a newbie at all. I've been coding in PHP, mySQL
> for like 6 years now. But I just never learned (or maybe had a reason
> to) why I would use "KEY (a_id, b_id)" rather than "KEY (a_id)" and
> "KEY (b_id)". Would someone be so
I wouldn't say I was a newbie at all. I've been coding in PHP, mySQL for
like 6 years now. But I just never learned (or maybe had a reason to) why I
would use "KEY (a_id, b_id)" rather than "KEY (a_id)" and "KEY (b_id)".
Would someone be so kind as to point me at an online tutorial or just
explain