You have an error in your SQL syntax!
-
Hi, I am trying to create this stored proceedure on mysql but getting the following error:
Quote:
[Err] 1064 - 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 'PROCEDURE sp_add_event_log ( IN param_event_log_category varcha' at line 1
DROP PROCEDURE IF EXISTS `sp_add_event_log`;
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
IN param_event_log_category varchar(255),
IN param_event_log_reference varchar(255),
IN param_event_log_user varchar(255),
IN param_event_log_machine_name varchar(255),
IN param_event_log_os_version varchar(255),
IN param_event_log_windows_user varchar(255),
IN param_event_log_windows_user_domain varchar(255),
IN param_event_log_processor_count int,
IN param_event_log_stack_trace text,
IN param_event_log_working_set int,
IN param_event_log_tick_count int,
IN param_event_log_current_culture varchar(255),
IN param_event_log_date_time_format varchar(255),
IN param_event_log_number_format varchar(255),
IN param_event_log_language_name varchar(255),
IN param_event_log_text text
)
BEGIN
INSERT INTO students
(
event_log_category,
event_log_reference,
event_log_user,
event_log_machine_name,
event_log_os_version,
event_log_windows_user,
event_log_windows_user_domain,
event_log_processor_count,
event_log_stack_trace,
event_log_working_set,
event_log_tick_count,
event_log_current_culture,
event_log_date_time_format,
event_log_number_format,
event_log_language_name,
event_log_text
)
VALUES
(
param_event_log_category,
param_event_log_reference,
param_event_log_user,
param_event_log_machine_name,
param_event_log_os_version,
param_event_log_windows_user,
param_event_log_windows_user_domain,
param_event_log_processor_count,
param_event_log_stack_trace,
param_event_log_working_set,
param_event_log_tick_count,
param_event_log_current_culture,
param_event_log_date_time_format,
param_event_log_number_format,
param_event_log_language_name,
param_event_log_text
) ;
END -
Hi, I am trying to create this stored proceedure on mysql but getting the following error:
Quote:
[Err] 1064 - 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 'PROCEDURE sp_add_event_log ( IN param_event_log_category varcha' at line 1
DROP PROCEDURE IF EXISTS `sp_add_event_log`;
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
IN param_event_log_category varchar(255),
IN param_event_log_reference varchar(255),
IN param_event_log_user varchar(255),
IN param_event_log_machine_name varchar(255),
IN param_event_log_os_version varchar(255),
IN param_event_log_windows_user varchar(255),
IN param_event_log_windows_user_domain varchar(255),
IN param_event_log_processor_count int,
IN param_event_log_stack_trace text,
IN param_event_log_working_set int,
IN param_event_log_tick_count int,
IN param_event_log_current_culture varchar(255),
IN param_event_log_date_time_format varchar(255),
IN param_event_log_number_format varchar(255),
IN param_event_log_language_name varchar(255),
IN param_event_log_text text
)
BEGIN
INSERT INTO students
(
event_log_category,
event_log_reference,
event_log_user,
event_log_machine_name,
event_log_os_version,
event_log_windows_user,
event_log_windows_user_domain,
event_log_processor_count,
event_log_stack_trace,
event_log_working_set,
event_log_tick_count,
event_log_current_culture,
event_log_date_time_format,
event_log_number_format,
event_log_language_name,
event_log_text
)
VALUES
(
param_event_log_category,
param_event_log_reference,
param_event_log_user,
param_event_log_machine_name,
param_event_log_os_version,
param_event_log_windows_user,
param_event_log_windows_user_domain,
param_event_log_processor_count,
param_event_log_stack_trace,
param_event_log_working_set,
param_event_log_tick_count,
param_event_log_current_culture,
param_event_log_date_time_format,
param_event_log_number_format,
param_event_log_language_name,
param_event_log_text
) ;
ENDJust a guess, but shouldn't it be
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
...
...
)
AS <<== I don't see this in your SQL
BEGIN
...
...Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
Just a guess, but shouldn't it be
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
...
...
)
AS <<== I don't see this in your SQL
BEGIN
...
...Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
Then how can i say CREATE it if it does not exist and REACE if exist?
-
Then how can i say CREATE it if it does not exist and REACE if exist?
I think just the "AS" keyword is missing from your original code. The use of CREATE OR REPLACE is valid at anytime. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]