mysql> use mysql
Database changed
mysql> CALL P_PTC_SQLGEN_MYSQL5('help_topic');
+-----------------------+
| Insert SQL            |
+-----------------------+
| INSERT help_topic (   |
|    help_topic_id,     |
|    name,              |
|    help_category_id,  |
|    description,       |
|    example,           |
|    url)               |
| VALUES (              |
|    _help_topic_id,    |
|    _name,             |
|    _help_category_id, |
|    _description,      |
|    _example,          |
|    _url);             |
+-----------------------+
14 rows in set (7.93 sec)

+--------------------------------------+
| Select SQL                           |
+--------------------------------------+
| SELECT                               |
|    A.help_topic_id,                  |
|    A.name,                           |
|    A.help_category_id,               |
|    A.description,                    |
|    A.example,                        |
|    A.url                             |
| FROM                                 |
|    help_topic AS A                   |
| WHERE                                |
|    A.help_topic_id = _help_topic_id; |
+--------------------------------------+
11 rows in set (7.93 sec)

+------------------------------------------+
| Update SQL                               |
+------------------------------------------+
| UPDATE help_topic SET                    |
|    name = _name,                         |
|    help_category_id = _help_category_id, |
|    description = _description,           |
|    example = _example,                   |
|    url = _url                            |
| WHERE                                    |
|    help_topic_id = _help_topic_id;       |
+------------------------------------------+
8 rows in set (7.93 sec)

+------------------------------------+
| Delete SQL                         |
+------------------------------------+
| DELETE FROM                        |
|    help_topic                      |
| WHERE                              |
|    help_topic_id = _help_topic_id; |
+------------------------------------+
4 rows in set (7.93 sec)

+--------------------------------------------+
| Stored Procedure SQL                       |
+--------------------------------------------+
| DELIMITER $$                               |
|                                            |
| DROP PROCEDURE IF EXISTS P_help_topic_I1$$ |
| CREATE PROCEDURE P_help_topic_I1 (         |
|    _help_topic_id int,                     |
|    _name char(64),                         |
|    _help_category_id smallint,             |
|    _description text,                      |
|    _example text,                          |
|    _url char(128))                         |
| BEGIN                                      |
|                                            |
| INSERT help_topic (                        |
|    help_topic_id,                          |
|    name,                                   |
|    help_category_id,                       |
|    description,                            |
|    example,                                |
|    url)                                    |
| VALUES (                                   |
|    _help_topic_id,                         |
|    _name,                                  |
|    _help_category_id,                      |
|    _description,                           |
|    _example,                               |
|    _url);                                  |
|                                            |
| END$$                                      |
| DROP PROCEDURE IF EXISTS P_help_topic_S1$$ |
| CREATE PROCEDURE P_help_topic_S1 (         |
|    _help_topic_id int)                     |
| BEGIN                                      |
|                                            |
| SELECT                                     |
|    A.help_topic_id,                        |
|    A.name,                                 |
|    A.help_category_id,                     |
|    A.description,                          |
|    A.example,                              |
|    A.url                                   |
| FROM                                       |
|    help_topic AS A                         |
| WHERE                                      |
|    A.help_topic_id = _help_topic_id;       |
|                                            |
| END$$                                      |
| DROP PROCEDURE IF EXISTS P_help_topic_U1$$ |
| CREATE PROCEDURE P_help_topic_U1 (         |
|    _help_topic_id int,                     |
|    _name char(64),                         |
|    _help_category_id smallint,             |
|    _description text,                      |
|    _example text,                          |
|    _url char(128))                         |
| BEGIN                                      |
|                                            |
| UPDATE help_topic SET                      |
|    name = _name,                           |
|    help_category_id = _help_category_id,   |
|    description = _description,             |
|    example = _example,                     |
|    url = _url                              |
| WHERE                                      |
|    help_topic_id = _help_topic_id;         |
|                                            |
| END$$                                      |
| DROP PROCEDURE IF EXISTS P_help_topic_D1$$ |
| CREATE PROCEDURE P_help_topic_D1 (         |
|    _help_topic_id int)                     |
| BEGIN                                      |
|                                            |
| DELETE FROM                                |
|    help_topic                              |
| WHERE                                      |
|    help_topic_id = _help_topic_id;         |
|                                            |
| END$$                                      |
| DELIMITER ;                                |
|                                            |
+--------------------------------------------+
79 rows in set (7.93 sec)

Query OK, 0 rows affected, 1 warning (8.28 sec)

mysql>