Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Problem In Creating Stored Procedure

forums › forums › SQLyog › Query Builder and Schema Designer › Problem In Creating Stored Procedure

Tagged: 

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 4, 2012 at 3:31 am #12834
      pseudocod
      Member

      DELIMITER //

      CREATE PROCEDURE NEW_CUST(IN c_name VARCHAR(50),IN c_fname VARCHAR(50),IN c_g_n VARCHAR(50),IN c_address VARCHAR(50),IN c_city VARCHAR(50),IN c_cont INT)

      BEGIN

      INSERT INTO customer_info(c_name,c_fname,c_g_n,c_address,c_city,c_contact)

      VALUES(c_name,c_fname,c_g_n,c_address,c_city,c_contact)

      END//

      DELIMITER ;

      i m not able to compile this 'new_cust' stored procedure. Please make me correct.

      sqlYog is reporting this error number : 1064

      Error Description : 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 5…

      Actually I m from sql server background and got to work with mysql. Hope you would understand my problem.

      Thank you!

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.