[CS-FSLUG] Moving things around in SQL
Timothy Butler
tbutler at ofb.biz
Sat Nov 17 22:55:20 CST 2012
Hello, friends,
Let's say I have two columns in MySQL named body and extbody. Is there any easy way, entirely within a SQL query to take everything in extbody and append it to the existing body column for every row in the table? I've rethought the way I want to structure a MySQL table for a web app I've been working on and need to rapidly move the data around in four or five different installations, so doing so entirely in a self-contained query would make it a lot faster process...
Thanks,
Tim
More information about the Christiansource
mailing list