CODEWITHSUNDEEP
mysqlsql
Rik99
Rik99

Reputation: 79

Delete the contents of a column

I have a table called users with this

enter image description here

What is the correct query for delete ONLY the data in field telephone?

Upvotes: 1

Views: 171

Answers (2)

Tom Mulkins
Tom Mulkins

Reputation: 441

You wouldn't delete the data per se, just perform an UPDATE like so:

UPDATE users set telephone = 0

Edit to consider INT field. Answered elsewhere in any case.

Upvotes: 0

ollaw
ollaw

Reputation: 2193

UPDATE USERS SET TELEPHONE = NULL

Upvotes: 6

Related Questions