MYSQL存储过程简单示例

      
        BEGIN
      
      
        CREATE
      
      
        TEMPORARY
      
      
        TABLE
      
      
         `tmp_table` ( 



    `name` 
      
      
        VARCHAR
      
      (
      
        100
      
      ) 
      
        NOT
      
      
        NULL
      
      
        , 



    `value` 
      
      
        VARCHAR
      
      (
      
        100
      
      ) 
      
        NOT
      
      
        NULL
      
      
         



);




      
      
        insert
      
      
        into
      
       `tmp_table` 
      
        select
      
       `userName` 
      
        as
      
       `name`,`realName` 
      
        as
      
       `value` 
      
        from
      
       `userinfo` 
      
        where
      
       `isDeleted`
      
        =
      
      
        0
      
       limit 
      
        10
      
      
        ;




      
      
        update
      
       `tmp_table` 
      
        set
      
       `name`
      
        =
      
      
        '
      
      
        test
      
      
        '
      
      ,`value`
      
        =
      
      
        '
      
      
        测试数据
      
      
        '
      
      
        ;




      
      
        select
      
      
        *
      
      
        from
      
      
         `tmp_table`;




      
      
        drop
      
      
        table
      
      
         `tmp_table`;




      
      
        END
      
    

      CALL pro_test;