|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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. |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > PhpMyadmin key setup |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|