jingshanglu opened a new issue #8558:
URL: https://github.com/apache/shardingsphere/issues/8558


   expect formart of insert like :
   ```
   // insert_with_muti_values
   INSERT  INTO t_order_item (order_id , user_id , status , creation_date)
   VALUES
        (1, 1, 'insert', '2017-08-08'),
        (2, 2, 'insert', '2017-08-08')
   ON DUPLICATE KEY UPDATE status = 'init'
   
   // insert_with_muti_set
   INSERT  INTO t_order SET order_id = 1,
        user_id = 1,
        status = CONVERT(to_base64(aes_encrypt(1 , 'key')) USING utf8)
   ON DUPLICATE KEY UPDATE status = VALUES(status)
   
   // insert_with_select
   INSERT  INTO t_order (order_id , user_id , status) 
   SELECT order_id , user_id , status 
   FROM t_order
   WHERE 
        order_id = 1;
   
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to