插入数据
- INSERT INTO table_name VALUES (value1,value2,value3,…);
- INSERT INTO table_name (column1,column2,column3,…) VALUES (value1,value2,value3,…);
直接插入数据: INSERT INTO `py_test1` VALUES (1,"Lucy")
将另外一张表的数据插入 当前表中:
INSERT INTO `py_test1` (id,name_com) SELECT py_private_id,full_name from `py_etl_private_fund_base_info_2_1`
赋值表: CREATE TABLE `py_copy` SELECT py_private_id