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

  • This topic is empty.
Viewing 0 reply threads
  • Author
    • #12834

      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)


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




      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!

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