DELIMITER $$

// -----------------------------------------------------------------------------

DROP PROCEDURE IF EXISTS `test`.`create_index`$$
CREATE PROCEDURE `test`.`create_index`()
BEGIN
  create index my_index on tbl1 (ID);
END$$

// -----------------------------------------------------------------------------

DROP PROCEDURE IF EXISTS `test`.`myjoin`$$
CREATE PROCEDURE `test`.`myjoin`()
BEGIN
  update tbl1, tbl2 set tbl1.txt = tbl2.txt where tbl1.id = tbl2.id;
END$$

// -----------------------------------------------------------------------------

DROP PROCEDURE IF EXISTS `test`.`truncate_table`$$
CREATE PROCEDURE `test`.`truncate_table`()
BEGIN
  TRUNCATE TABLE tbl1;
END$$

// -----------------------------------------------------------------------------

DELIMITER ;