Thank you steve.

select column_name from information_schema.columns

where table_name= 'tablename'

if I type * instead of column_name it is giving database name not columns name.

Thank You Gah . It worked out

My table contains

eid fname lname gender age title

I want to print like this

eid

fname

lname

gender

age

title .

How do i know that no of records updated without seeing the table ?

in one transaction 1 record or multiple records can be updated.

Is there any way finding out...

Thank you .

Cheers . 😀