Re: Deleting column data & LOAD question

2003-11-19 Thread William Fong
ut security. -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "Patrick Larkin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 11:47 AM Subject: Deleting column data &

Deleting column data & LOAD question

2003-11-19 Thread Patrick Larkin
Hello - what would the syntax be to delete all the data in a column for every record but still maintain the column? In other words, I don't want to delete the column, just the data in it. Second, is there a way I can LOAD a file of plain text passwords into a mysql database and encrypt them d