Results 1 to 1 of 1

Thread: insert procedure in mysql

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    insert procedure in mysql

    I have table
    {code}
    Create table PostDeferment(
    UserId int Not null auto_increment ,
    UniversityN varchar(10) Not null,
    AstComposition varchar(5) Null,
    BstComposition varchar(5) default null,
    ACompositionDue varchar(10) default null,
    BCompositionDue varchar(10) default null,
    AstHall varchar(5) default Null,
    BstHall varchar(5) Null,
    AHallDute varchar(10) default null,
    BHallDute varchar(10) default null,
    ContinueFee varchar(5) Null,
    Specify varchar(10) Null,
    ContinueDute varchar(10) default null,
    EnglishName varchar(35) default null,
    ChineseName varchar(25) default null,
    IdNumber varchar(15) default null,
    Hall varchar(50) default null,
    Year varchar(5) default Null,
    Curriculum varchar(100) default Null,
    Faculty varchar(70) default Null,
    Department varchar(70) default Null,
    FPT varchar(5) default Null,
    Address varchar(150) default Null,
    Telephone varchar(20) default Null,
    Mobile varchar(20) default Null,
    Email varchar(32) default Null,
    RegistDate varchar(10) default null,
    Supervisor varchar(5) default null,
    GL varchar(5) default null,
    GLSubmit varchar(10) default null,
    GLR varchar(5) default null,
    GLGrantA varchar(8) default null,
    GLoanA varchar(8) default null,
    GLRDate varchar(10) default null,
    EL varchar(5) default null,
    ELSubmit varchar(10) default null,
    ELR varchar(5) default null,
    ELDate varchar(10) default null,
    ELPayDate varchar(10) default null,
    StudentShip varchar(5) default null,
    StudentShipdate varchar(10) default null,
    TassistantStart varchar(10) default null,
    TassistantUntill varchar(10) default null,
    Tassistant varchar(2) default null,
    Reasons varchar(150) default null,
    PRIMARY KEY (UserId)

    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    {/code}
    then I try to create a insert procedure
    {code}
    delimiter//
    create Procudure PostDeferment(
    IN UserId INT(2),
    IN UniversityN VARCHAR(10),
    IN AstComposition varchar(5),
    IN AstComposition varchar(5),
    IN BstComposition varchar(5),
    IN ACompositionDue varchar(10),
    IN BCompositionDue varchar(10),
    IN AstHall varchar(5),
    IN BstHall varchar(5),
    IN AHallDute varchar(10)
    IN BHallDute varchar(10),
    IN ContinueFee varchar(5),
    IN Specify varchar(10),
    IN ContinueDute varchar(10),
    IN EnglishName varchar(35),
    IN ChineseName varchar(25),
    IN IdNumber varchar(15) ,
    IN Hall varchar(50) ,
    IN Year varchar(5) ,
    IN Curriculum varchar(100),
    IN Faculty varchar(70),
    IN Department varchar(70),
    IN FPT varchar(5),
    IN Address varchar(150),
    IN Telephone varchar(20),
    IN Mobile varchar(20),
    IN Email varchar(32),
    IN RegistDate varchar(10),
    IN Supervisor varchar(5),
    IN GL varchar(5),
    IN GLSubmit varchar(10),
    IN GLR varchar(5),
    IN GLGrantA varchar(8),
    IN GLoanA varchar(8),
    IN GLRDate varchar(10),
    IN EL varchar(5),
    IN ELSubmit varchar(10),
    IN ELR varchar(5),
    IN ELDate varchar(10) ,
    IN ELPayDate varchar(10) ,
    IN StudentShip varchar(5) ,
    IN StudentShipdate varchar(10) ,
    IN TassistantStart varchar(10) ,
    IN TassistantUntill varchar(10),
    IN Tassistant varchar(2) ,
    IN Reasons varchar(150) default null,

    )
    Begin
    insert into PostDeferment values(UserId,UniversityN,AstComposition,BstCompos ition,ACompositionDue,BCompositionDue
    , AstHall,BstHall,AHallDute,BHallDute,ContinueFee,Sp ecify,ContinueDute,
    EnglishName,ChineseName,IdNumber,Hall,Year,Curricu lum,Faculty,Department,FPT,Address,Telephone,Mobil e,
    Email,RegistDate,Supervisor,GL,GLSubmit,GLR,GLGran tA,GLoanA,GLRDate,EL,ELSubmit,ELR,ELDate
    ,ELPayDate,StudentShip,StudentShipdate,TassistantS tart,TassistantUntill,Tassistant,Reasons);
    end;//
    I got error ERROR 1064 (42000): 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 'end' at line 1

    {/code}
    ________
    VAPORIZER REVIEW
    Last edited by sql; 03-06-2011 at 02:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •