Creating a stored procedure in MySQL Workbench

Question

Does anyone know how I can create a stored procedure in mysql workbench? I would like to know and use them, but how to save the files that I create so that I can name them later? In a workbench or inside my php code would be better.

update thought I could share this link, as this can come in handy to anyone who views this

Stored procedures in MySQL and PHP as an article

Answer 1

add stored procedure to Workbench Mysql:

1) Click the triangle to the left of your database: you should see tables, views and routines

2) Right-click on procedures → Create procedure

You are done :)

Answer 2

In the EER chart:

• Click the Place a New Routine Group toolbar icon and
• Place a routine group.
• Double-click the resulting rectangle to edit it.
• Go to the Group: Routines tab Group: Routines and
• Click the bottom tab of the Routine Group to edit the group or
• Click the bottom tab of Routines to edit the actual procedures.

Alternatively, from the model diagram, click the Add Group icon under the Routine Groups heading, then click Add Routine under the Routines heading.

Source: dev.mysql.com