Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by edwonglsc
-
question on index and primary key
yup. my mistake. will use single primary key (id) and index(username) -
question on index and primary key
omg... i thought primary key will be indexed automatically... thx -
question on index and primary key
| stat | CREATE TABLE `stat` ( `id` int(11) NOT NULL auto_increment, `username` varchar(20) NOT NULL, `page` varchar(255) NOT NULL, `time` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`,`username`,`page`) ) ENGINE=MyISAM AUTO_INCREMENT=13359 DEFAULT... -
question on index and primary key
I have the following table - stat +----------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | |...
