SQL Update help plz
this isn't really a 'linux' question, but you guys are smart so hopefully someone will have an idea how to do this:
Using MySQL,
I need to find a way to, well, what would in effect be running many "update" queries in 1. heres what im trying to do:
I have a column, name it col1. It has data in it already, I have added a new column, name it col2. I need to copy all info in col1 to col2 on every row. Short of running an update query for every row in the table, I dont know how to do this.
any ideas?
|