SHOW COLUMNS FROM Table_name LIMIT 0,5

[gert cuykens]

(mysql 5.0) I need to specify a limit on SHOW COLUMNS FROM Table_name LIMIT 0,5 But limit doesnt work with SHOW. Is there a SELECT alternative ?

[NogDog]

Don't know if this would be any different, but you could try it with DESCRIBE table_name and see what happens.

[gert cuykens]

nope doesnt work. Why cant they just make the basic things work first before they start adding new mysql features :mad:

[NogDog]

Well, I have to admit: I've never run into a situation where I wanted to show/describe only the first n columns of a table. :)

[gert cuykens]

i did , sort off in my imagenary table :D