howto copy some rows to other ones in mysql -


Can anyone tell me how I can copy some lines like this:

ID 1

example from copy id field: 

  1 foo ... 31 bla   
 after that it should be Is:  
  1 foo ... 31 foo    
 
 < P> Something like this ..  
  update tablename SET field name = (Select tablename.fieldname from tablename t2 where t2.id = (tablename.id-30)) where between 31 tablename. Id 40;

Comments

Post a Comment