Newbie needs help with syntax
I get the following error from mysql cli when I try and run this procedure;
ERROR 1064 (42000): 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 '@newstr varchar(200);
This is the procedure;
drop procedure if exists `network`.`procNetDebugVarChar`;
delimiter $$
create procedure `network`.`procNetDebugVarChar`()
begin
declare @newstr varchar(200);
set @newstr = 'hello world';
end $$
delimiter ;
Can anyone tell me what is wrong with the syntax?
Subject
Written By
Posted
Newbie needs help with syntax
July 28, 2025 07:32PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.