Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Query Builder and Schema Designer › Problem In Creating Stored Procedure
Tagged: stored procedure
This topic contains 1 reply, has 0 voices, and was last updated by pseudocod 6 years, 8 months ago.
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.
You must be logged in to reply to this topic.