dongzheng7165 2015-09-23 14:18
浏览 183

使用mysql存储过程插入多个表

CREATE PROCEDURE rbuilder(
    IN uid INT,IN name VARCHAR(30),
    IN sex VARCHAR(1),
    IN dob DATE,
    IN address VARCHAR(200),
    IN country VARCHAR(2),
    IN state VARCHAR(20),
    IN city VARCHAR(20),
    IN zip VARCHAR(10),
    IN mobile VARCHAR(10),
    IN email VARCHAR(30),
    IN aoe VARCHAR(250),
    IN planguages VARCHAR(250)
    IN comments VARCHAR(250)
) BEGIN

    START TRANSACTION

    INSERT INTO rbuilder_info (uid,name,sex,dob,address,country,state,city,zipcode,mobile,email)VALUES('',uid,name,sex,dob,address,country,state,city,zip,mobile,email);

    INSERT INTO rabuilder_skills VALUES('',aoe,planguages,coments);

    COMMIT

END

Please do help me to make it work showing some syntax error;

#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 'INSERT INTO rbuilder_info (uid,name,sex,dob,address,country,state,city,zipcode,m'

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?