[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