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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. edwonglsc

    question on index and primary key

    yup. my mistake. will use single primary key (id) and index(username)
  2. edwonglsc

    question on index and primary key

    omg... i thought primary key will be indexed automatically... thx
  3. edwonglsc

    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...
  4. edwonglsc

    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 | |...

Part and Inventory Search

Back
Top