mysql-MySQL数据导入到同数据库的另一张不存在的表，请教我写的有什么问题，创建表的时候ID报错

create table if not exists pjm_project_group
(
'pjm_project_group_id' varchar(32) ,
'category_id' varchar(32) ,
'rz_org_id' varchar(32) ,
'db_org_id' varchar(32) ,
'org_agent_id' varchar(32),
'title' varchar(128) ,
'code' varchar(15) ,
'money' decimal(16,2) ,
'contract_url' varchar(128) ,
'invest_lowest' decimal(16,2) ,
'invest_add' decimal(16,2) ,
'min_income' decimal(16,2) ,
'max_income' decimal(16,2) ,
'type' char(4) ,
'repay_type' char(4) ,
'site_fee' decimal(16,2) ,
'status' char(10) ,
'create_staff_id' varchar(32) ,
'create_time' datetime ,
'update_staff_id' varchar(32) ,
'update_time' datetime ,
'check_staff_id' varchar(32) ,
'check_staff_id' datetime ,
)
create procedure datashift()
begin
insert into pjm_project_group('pjm_project_group_id','category_id','rz_org_id','db_org_id','org_agent_id','title','code','min_income','max_income','type','repay_type','site_fee')
select project_id,category_id,rz_org_id,db_org_id,org_agent_id,title,code,year_income,year_income,loan_type,repay_type,site_fee
from pjm_project
end

CALL dataShift()

pollinations

属于你的个性化媒体引擎

231

查看详情

错误信息：[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''PJM_PROJECT_GROUP_ID' VARCHAR(32) ,
'CATEGORY_ID' VARCHAR(32) ,
'RZ_ORG_ID'' at line 3