WampServer

I hav e created store procedure
DELIMITER
USE test;
CREATE PROCEDURE check_user_pass (username VARCHAR(10))
BEGIN
SELECT user_id FROM users
WHERE user_id = username ;
END;
DELIMITER

When I try it in my WAMP (sqlbuddy) by using console i get a following errors:
1.ERROR:
DELIMITER must be followed by a 'delimiter' character or string
2. 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 '' at
line 4

Does anybody know what a problem? In some places is written that sql buddy don't work with store procedures. Is that right?

Thank you

DELIMITER $$
USE test;
CREATE PROCEDURE check_user_pass (username VARCHAR(10))
BEGIN
SELECT user_id FROM users
WHERE user_id = username ;
END;
DELIMITER ;

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

That what i have when i write it now

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 'DELIMITER $$ USE test' at line 1
No database selected
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 1
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 'DELIMITER' at line 1

I can not find even an option for stored procedure in SQL BUDDY. Is there the option to install something or to add in order to work with stored procedures like in MySQL? Are there any options to work with another db in wamp?

Try a tutorial on how to write a stored proceedure.

[net.tutsplus.com]

Also try using phpMyAdmin its a bit more comprehensive.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-