Selecting single column or some columns using mysql query?

See the Example Select * from mydoubts_data +———+————————-+——————–+ | EMPCODE | NAME | SALARAY CODE | +———+————————-+——————–+ | 787 | Vasanthan | K | | GORT | Shaji | S | | GKL | James | P | | IND | Abdul | ZO | | VIS | Sunil | F | +———+————————-+——————–+ For only… Read More »

Selecting a particular record using mysql query?

See the Example Select * from mydoubts_data +———+————————-+——————–+ | EMPCODE | NAME | SALARAY CODE | +———+————————-+——————–+ | 787 | Vasanthan | K | | GORT | Shaji | S | | GKL | James | P | | IND | Abdul | ZO | | VIS | Sunil | F | +———+————————-+——————–+ For finding… Read More »

Importance of wild card ‘*’ in mysql

See the Example Select * from mydoubts_data +———+————————-+——————–+ | EMPCODE | NAME | SALARAY CODE | +———+————————-+——————–+ | 787 | Vasanthan | K | | GORT | Shaji | S | | GKL | James | P | | IND | Abdul | ZO | | VIS | Sunil | F | +———+————————-+——————–+ For finding… Read More »

Finding how many rows in a table in Mysql?

See the Example Select * from mydoubts_data +———+————————-+——————–+ | EMPCODE | NAME | SALARAY CODE | +———+————————-+——————–+ | 787 | Vasanthan | K | | GORT | Shaji | S | | GKL | James | P | | IND | Abdul | ZO | | VIS | Sunil | F | +———+————————-+——————–+ For finding… Read More »

Indexing in mysql using php

indexes in mysql will increase the speed of your mysql queries. indexes are doing cloumn basis. for example if you have table with following fields ID,jobdescription,salary In this case to speed up the queries with jobdescription. then create an index for jobdescription. CREATE TABLE mydoubts_data ( jobdescription varchar, INDEX (jobdescription), salary INT(50), )