Member Avatar for jegana

Table name: upload

Id Name Email File
153 Jegan jeg@yahoo.com id.doc
154 Alex Alx@gmail.com de.doc

Consider the above table,
I want to delete the Alx@gmail.com in 154.
Plz give the idea.

Edited by jegana because: n/a
  • 2 Contributors
  • 3 Replies
  • 89 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by smantscheff

Recommended Answers

All 3 Replies

Member Avatar for smantscheff

RTFM.
And try

update upload set email=null where id=154;
Member Avatar for jegana

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

Member Avatar for smantscheff

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.