Thursday, July 12, 2012

difference between index, primary, full text, unique in phpmyadmin

In phpmyadmin, we can set attribute for a field with following properties :
  • 1. Index
  • 2. Primary
  • 3. Full Text
  • 4. Unique

Then what is the difference between index, primary, full text,unique in phpmyadmin.
Index: this create a non-unique columns.
primary: there will be one primary key for a table.
fulltext: this is used for full text searching. but others are used for b-treee(selecting, sorting, ranges from left most column) or hash table.
unique: this will be unique throughout the columns

See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

1 comment:

Todaydownload.com said...

These facts are really interesting. Few of them were well known for me but many of them were brand new for me too!
I will print this one out and show to my friends because they will be definitely interested in that. Thanks!
phpMyAdmin