SQL Index?

[BoratSagdiyev]

Hello English friend what what what! My name Borat, like English Barry--But people call me Steve--STEVE!

Recently I do install of XAMPP and try to create database. I have problem, phpmyadmin say "no index defined" for my table. What is this index and how do I solve this problem?

Many thanks in advance. Jinqui!

[Izzy]

Hello Barry or Steve, my name in English is Izzy but people call me all sorts of names.

Try and explain what you are doing to get this error if you can.

For an example, in phpMyAdmin click on the MySQL database then click on a table and you will see an Indexes box with a ? mark which leads to the link below - don't change anything in this database or you may have real problems and have to reinstall XAMPP but its OK to read how it is done.


Help on Indexes and other database structures can be read here - it explains all about indexes:
http://dev.mysql.com/doc/refman/5.0/en/ ... cture.html


===========================================
1. The new DeskTopXampp Launch Control for XAMPP / XAMPPlite
Posted by Ridgewood available from Ridgewood'sDTX web site

2. Build Rich AJAX Applications - Faster
TIBCO General Interface Pro Edition but FREE and Open Source
Fully working with NO donations required to get a user/password
===========================================

[BoratSagdiyev]

How do I insert entries into my table? Do I need to create a primary index?

[Scory]

You should read a book about SQL first - you obviously have no idea about tables, indexes, keys and so on. As this is basic knowledge, you should read about it before starting to work.

This board cannot replace a book nor the documentation for (My)SQL.

Regards
Scory