title: Use is not valid input at this position MySQL Workbench
body: <p>I'm trying to create a stored procedure in MySQL Workbench:</p>
  
  <pre><code>USE `data_p`;
  DROP PROCEDURE IF EXISTS `Product`;
  DELIMITER $$
  USE `data_p`$$
  CREATE DEFINER=`data_s_admin`@`...` PROCEDURE `Product`(
  
    INOUT d_id INT,
    INOUT d_fk_c INT,
    INOUT d_s VARCHAR(255),
    INOUT d_p DECIMAL,
    INOUT d_c_a DATE,
    INOUT d_o_p DECIMAL,
    INOUT d_s_c DECIMAL,
    INOUT d_x_s VARCHAR(20),
    INOUT d_d_w VARCHAR(20),
    INOUT d_fk_c_a INT,
    INOUT d_s enum('ac','in','de')
  )
  
  BEGIN
      DECLARE cs_id INT;
      DECLARE cs_fk_c INT;
      DECLARE cs_s VARCHAR(255);
      DECLARE cs_p DECIMAL;
      DECLARE cs_c_a DATE;
      DECLARE cs_o_p DECIMAL;
      DECLARE cs_s_c DECIMAL;
      DECLARE cs_x_s VARCHAR(20);
      DECLARE cs_d_w VARCHAR(20);
      DECLARE cs_fk_c_a INT;
      DECLARE cs_s enum('ac','in','de');
  
   SELECT 
  
     d_id ,
     d_fk_c ,
     d_s,
      d_p ,
     d_c_a ,
     d_o_p ,
     d_s_c ,
     d_x_s,
     d_d_w,
     d_fk_c_a,
     d_s
   )
   INTO 
  
    cs_id,
    cs_fk_c,
    cs_s,
    cs_p,
    cs_c_a,
    cs_o_p,
    cs_s_c,
    cs_x_s,
    cs_d_w,
    cs_fk_c_a,
    cs_s
  
   FROM 
  
          data_p.cas
   WHERE 
          cs_s = d_s AND cs_s = 'ac';
  
   END $$
   DELIMITER ;
  </code></pre>
  
  <p>When i click on data_s==> stored procedures, i create new stored procedure and then i paste this code,
  my errors are : 
  Syntax error: 'USE' is not valid input at this position
  Syntax error: IF : unexpected at this position</p>
  
  <p>What is the problem? i really want to fix this to know how many rows affected </p>
  
  <p>I create my stored procedure in database 'data_s' and i return all data from 'data_p '</p>
  
  <p>Can anyone help me please.</p>
  
  <p>Many thanks for any help</p>