[SOLVED] exclude row

[M.O.S. Studios]

hey,

I want to remove the `index` column from the `storeinfo` table in the results of a mysql query

 

any one know the prober syntax???

here is the code on the bottom?

 

SELECT `emails`.`New orders` , `settings`.`site_folder` , `storeinfo` . * FROM `emails` , `settings` ,`storeinfo`

 

thanks in advance

[pkedpker]

`storeinfo` . *

 

* means it will select ALL...

 

if you don't want index it it.. then don't use the *.

 

instead do like..

 

`storeinfo` . something, `storeinfo` . something2, `storeinfo` . something3..

 

but you see doing it your way just to get rid of index.. is soo much longer.. and worse

[M.O.S. Studios]

its not that big a deal, i will just live having the index in there.

 

 

thanks a lot

[Maq]

its not that big a deal, i will just live having the index in there.

 

 

thanks a lot

 

It is bad practice to use SELECT * unless you need all of the fields. Using * instead of listing just the required columns is not only inefficient, it also impacts the reliability and maintainability of your code.

 

Just list the columns you want, it's not difficult.

[M.O.S. Studios]

I agree, which is why i asked the question,

however in this case its only one column i don't need, so i think it will be fine