LCKB
Table merge - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: Table merge (/showthread.php?tid=2712)



- kixtzz - 11-23-2013


How i merge two tables like this image

How i can merge two tables like this image for example i have table 1 and 2 with same data, but I replace all the data in table 2 has more data does not change that shes different.




- luoo - 11-23-2013


Have the tables the same coloumns?

If yes try this

INSERT INTO table1 (SELECT * FROM table2 WHERE index >= X)

replace the x with the last id from table 1




- kixtzz - 11-23-2013

thanks i think its work ;D




- Paramount - 11-24-2013


Hi.

As you got your answer,and your problem to solved, I am gonna move that topic to Solved section.

Thanks,

-LCKB Staff