I always forget, can't remember. Googling kills lots of time. This blog is only for myself, but if you get any help from this, it will be a bonus for me.
Saturday, October 10, 2009
MySQL Insert from another table
Its easy to insert data to a table from another table in MySQL by query.
insert into database01.table1 (c1, c2, c3) select cx1, cx2, cx3 from database02.anotherTable
No comments:
Post a Comment