Hai
Can you tell me the `delete query` for deleting a field from database table.
ie
ID name Image_id Email
1 abc Qw2.jpg [email protected]
2 sss ss.jpg [email protected]

I have to delete `Image_id` only from `ID`=1 row;
Anybody help me!

__________________
Regards
Aneesh

hi try this,
if you want to delete the field from database use this
ALTER TABLE tblname DROP column Image_id

if you want to delete the records, use following
update tblname set Image_id = null where ID=1
or
update tblname set Image_id = "" where ID=1


surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

Hai Surendan
Thanks in advance for your response.
I already tried update query, i understand that delete is impossibe, only update is possible