数据库表里面加表中的数据

INSERT INTO shangpin (s_name ,s_leibie,s_danwei, s_price ) SELECT s_name ,s_leibie,s_danwei, s_price FROM shangpin;