3.2.6.2. Example Execution

shell> mysqlmetagrep --server=root:root@localhost --body --pattern='%cost%'
+------------------------+--------------+--------------+----------+-------------+------------------+
| Connection             | Object Type  | Object Name  | Database | Field Type  | Matches          |
+------------------------+--------------+--------------+----------+-------------+------------------+
| root:*@localhost:3306  | FUNCTION     | adjust_cost  | griots   | ROUTINE     | adjust_cost      |
| root:*@localhost:3306  | TABLE        | supplies     | griots   | COLUMN      | cost             |
| root:*@localhost:3306  | TABLE        | film         | sakila   | COLUMN      | replacement_cost |
+------------------------+--------------+--------------+-----------------+-------------+-------------+

shell> mysql -uroot -proot -e "SHOW CREATE FUNCTION griots.adjust_cost \G"
*************************** 1. row ***************************
            Function: adjust_cost
            sql_mode: 
     Create Function: CREATE DEFINER=`root`@`localhost` FUNCTION `adjust_cost`(cost double) 
     RETURNS double DETERMINISTIC
return cost * 1.10
character_set_client: latin1
collation_connection: latin1_swedish_ci
  Database Collation: latin1_swedish_ci        


User Comments
Sign Up Login You must be logged in to post a comment.