indexed table
Posted: Mon Mar 12, 2007 7:51 am
Hello,
I'm very new to php and databases and need to make a table for class.
My table is a glossary table. What is the best way to setup the table? I need to make it easy to search.
I have this so far:
My classmate told me that I have to index my word and deffinition to make it searchable but I'm not sure how? Do I index both fields? What about my id field?
Thanks!
I'm very new to php and databases and need to make a table for class.
My table is a glossary table. What is the best way to setup the table? I need to make it easy to search.
I have this so far:
Code: Select all
CREATE TABLE myglossary (
`id` int(11) unsigned NOT NULL auto_increment,
`word` text,
`deff` text,
`status` tinyint(1) default '1',
PRIMARY KEY ( `id` )
)Thanks!