neo777ph Posted March 8, 2007 Share Posted March 8, 2007 how do i define properly index on a row of a table.. can you please provide me a working sample of an index implementation. I want to learn it to fasten to my system query..thnx. Link to comment https://forums.phpfreaks.com/topic/41777-mysql-index-help/ Share on other sites More sharing options...
skali Posted March 8, 2007 Share Posted March 8, 2007 The syntax of creating an index is: CREATE [uNIQUE|FULLTEXT|SPATIAL] INDEX index_name [uSING index_type] ON tbl_name (index_col_name,...) Link to comment https://forums.phpfreaks.com/topic/41777-mysql-index-help/#findComment-202640 Share on other sites More sharing options...
neo777ph Posted March 9, 2007 Author Share Posted March 9, 2007 tnx...i will do that using phpmyadmin.. however,, how do i use is for my users..could you provide me a working sample? Link to comment https://forums.phpfreaks.com/topic/41777-mysql-index-help/#findComment-203099 Share on other sites More sharing options...
neo777ph Posted March 9, 2007 Author Share Posted March 9, 2007 help.. Link to comment https://forums.phpfreaks.com/topic/41777-mysql-index-help/#findComment-203215 Share on other sites More sharing options...
skali Posted March 9, 2007 Share Posted March 9, 2007 however,, how do i use is for my users ?? Didn't quite get you here... ??? Link to comment https://forums.phpfreaks.com/topic/41777-mysql-index-help/#findComment-203319 Share on other sites More sharing options...
neo777ph Posted March 10, 2007 Author Share Posted March 10, 2007 opps.. sorry.. what i mean is.. Can you provide me a working BASIC sample of Index implementation on PHP? For example, php built search engine that uses index so it would much faster to query. thanx Link to comment https://forums.phpfreaks.com/topic/41777-mysql-index-help/#findComment-204149 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.