behzad Posted December 17, 2007 Share Posted December 17, 2007 Hi there guys Is there a way to copy a cell from Mysql table to another cell ( Like copy Cell Where Row is X - Past Cell Where Row is Y ) Basically what it is, Someone has already created a entry in Mysql under some Cell and now likes to copy that cell some other cell. I know you could have a dropdown select all data related to that column then choose one and put it in new cell, but is the other way that would just copy past? Ben Quote Link to comment Share on other sites More sharing options...
rajivgonsalves Posted December 17, 2007 Share Posted December 17, 2007 do you mean one column to another if so you could do update table [tablename] set [columname1]=[columname2] where.... Quote Link to comment Share on other sites More sharing options...
behzad Posted December 17, 2007 Author Share Posted December 17, 2007 Well maybe I am, I have; ------------------------------------------------------------- Col 1 Col 2 Col n Row 1 VR1C1 *VR1C2 VR1C3 Cell From Here Row 2 VR2C1 VR2C2 VR2C3 Row 3 VR3C1 *VR1C2 VR3C3 To Cell Here ------------------------------------------------------------- In order to create cell "VR1C2" There are lots of steps, so since I have the value created already for "VR1C2" I just like to say to code copy Row1 Col2 to Row3 Col3. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.