SunQuest
           Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOther TechnologiesDatabase Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old February 9th, 2003, 09:13 AM
PhpPrincess PhpPrincess is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Los Angeles
Posts: 22 PhpPrincess User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
PhpMyadmin key setup

Hi,

I am trying to create a table using PhpMyadmin that has this:

CREATE TABLE `counter_ips` (
`ip` varchar(16) NOT NULL default '',
`page` varchar(100) default NULL,
`viewtime` int(11) unsigned NOT NULL default '0',
KEY `ip` (`ip`),
KEY `viewtime` (`viewtime`),
KEY `page` (`page`)
) TYPE=MyISAM;

I was able to create the table with ip, page, viewtime fields. but, How can I set up the KEY using PhpMyadmin?

Reply With Quote
  #2  
Old February 9th, 2003, 10:27 AM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: PhpMyadmin key setup

well, when you click on the table properties, you can see the "primary" under the actions panel.Click on that and you can enforce a key.when u intend to modify anything further, you can do it at the bottom where it displays all the keys related to the table under the heading indexes.

Sorry if I understood wrong and if you have'nt got your answer.

cheers

Reply With Quote
  #3  
Old February 9th, 2003, 09:37 PM
PhpPrincess PhpPrincess is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Los Angeles
Posts: 22 PhpPrincess User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
RE: PhpMyadmin key setup

I was able to find the Action section. What's the difference between Primary, Index, Unique, Fulltext keys?

I was reading the documentation on that, but it's not helpful. Since the code only says "KEY `page` (`page`)", I am not sure which key type it's referring to.

Reply With Quote
Reply

Viewing: Codewalkers ForumsOther TechnologiesDatabase Help > PhpMyadmin key setup


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway