CODEWITHSUNDEEP
mysqlsqlstored-procedures
Sergey Scopin
Sergey Scopin

Reputation: 2245

MySQL stored procedures Can't create

I want to create stored procedure I create it via Sequel Pro editor. Here is my query:

DELIMITER ;;
CREATE PROCEDURE 'selectValue' (IN surnamePart INT)
LANGUAGE SQL
BEGIN
SELECT id FROM mbus_clients WHERE second_name like surnamePart
END;;

It says what mistake is near ''selectValue' (IN surnamePart INT) LANGUAGE SQL'. What is wrong?

Upvotes: 1

Views: 4970

Answers (1)

juergen d
juergen d

Reputation: 204784

Use backticks to escape names, not quotes

CREATE PROCEDURE `selectValue` (IN surnamePart INT)

Upvotes: 3

Related Questions