Table name: upload

Id Name Email File
153 Jegan id.doc
154 Alex de.doc

Consider the above table,
I want to delete the in 154.
Plz give the idea.

And try

update upload set email=null where id=154;

Hey thanks ya. Am searching this for more then hour..

Maybe you should start with a mysql beginner's course. Or read a manual. It's all in there. And saves a lot of time.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.