> Rob, to clarify, your new 'index' column will be based on the value of > the 'part' column and individual column names from the old table? That is correct.
> Perhaps something like this, where [colnum] is derived from column name > like p1? (part+1)*[colnum] The actual formula I want to use is: `index` = (30 * part) + [colnum] The problem is I don't know how to implement this in an SQL statement - what I want is something like an INSERT...SELECT which can split the SELECTed columns of a single row (id, c1, c2, c3) into multiple rows in the INSERT: (id, 1, c1), (id, 2, c2), (id, 3, c3). Afaik there is no such thing so I need an equivalent method - one that isn't going to kill my server (like the several attempts I've made so far!) --Rob ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]