Hi all, I'm still a novice to jdbc, i want to know how to move rows of data from a table to another table. Is it as simple as select all data from table A then grab the resultSet and insert them to table B ? Can anyone give any example please? Any feedbacks will be fully appreciated
Duplicate entry '628151308255020050901000153496-nRn2Rkp4c01' for key
Looks like you are trying to write a key that already exists in the second table. Maybe you could you try using IF NOT EXISTS(Select colName from table) before your insert statement to make sure the value you are writing is unique.
I will open the floodgates of his own worst nightmare! All in a tiny ad:
ScroogeXHTML 8.0 - RTF to HTML5 and XHTML converter