Popularize Tables

Jump to bottom Edit New page

Yi Wang edited this page Oct 19, 2018 · 6 revisions

Popularize Tables

Hive

https://stackoverflow.com/questions/18049444/hive-select-into

create table people1990 as select * from people where dob_year=1990

MysQL

https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html

INSERT INTO tbl_temp2 (fld_id)
    SELECT tbl_temp1.fld_order_id
    FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;