Ok - I'm not a SQL guru. I extracted the data and created a spreadsheet that generated the SQL statements. I can execute each line individually. When I try to do more than one line it gives me a SQL Syntax error #1064. How do I paste in multiple lines to execute all at once so I don't get the error? I've tried line feed, comma and semicolon between the commands, but nothing works. Here is the sample data for 3 lines (of about 900)
update ubbt_POSTS set USER_ID=15 where POST_ID=2120
update ubbt_POSTS set USER_ID=24 where POST_ID=325
update ubbt_POSTS set USER_ID=24 where POST_ID=395
