Jump to content


Photo

How to Clear all data in the column?..


  • Please log in to reply
1 reply to this topic

#1 Dezept1p

Dezept1p

    Young Padawan

  • Members
  • Pip
  • 85 posts
  • Gender:Male
  • Location:www.prohoney.com
  • Interests:I like web-design, Rap and break dance<br />www.prohoney.com my web design studio.<br />Will be :)

Posted 06 August 2008 - 06:11 PM

How to Clear all data in the one column?.. :) (not DELETE FROM table,like truncate function).

#2 rc69

rc69

    PHP Master PD

  • P2L Staff
  • PipPipPipPip
  • 3827 posts
  • Gender:Male
  • Location:Here
  • Interests:Web Development

Posted 06 August 2008 - 06:45 PM

UPDATE `table` SET `column` = ''
http://dev.mysql.com.../en/update.html

Edited by rc69, 06 August 2008 - 06:46 PM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users