Stored procedures in MySQL can take parameters from the caller programme and return a result. Using standard syntax, SQL is embedded directly into the procedural code. Stored procedures, like tables and other database objects, can be created directly from the MySQL command line.