1.最长见的是insert into tb-name{【()】}values(····),
2.insert into tb_name set col_name=''''
3.insert into tb_name(tb_colname1.col_name2) select col_name1,col_name2 from tb_name2
1.最长见的是insert into tb-name{【()】}values(····),
2.insert into tb_name set col_name=''''
3.insert into tb_name(tb_colname1.col_name2) select col_name1,col_name2 from tb_name2