> 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.
I would use an UPDATE and set it to '' or NULL, depending on your column. > Second, is there a way I can LOAD a file of plain text passwords into a > mysql database and encrypt them during the LOAD process? I don't think you can run a function during LOAD DATA. But why not just do another UPDATE after it has been imported? Use a WRITE lock if you are worried about 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 & LOAD question > 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 during the LOAD process? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]