Skip to content

Instantly share code, notes, and snippets.

@jsntn

jsntn/MySQL_G.sql Secret

Last active August 29, 2015 14:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jsntn/e55578cbf5e94ddf574e to your computer and use it in GitHub Desktop.
Save jsntn/e55578cbf5e94ddf574e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL_G.sql
mysql> show procedure status like 'GET_ALLBSG_COUNTERS'\G;
*************************** 1. row ***************************
Db: cudb_user_data
Name: GET_ALLBSG_COUNTERS
Type: PROCEDURE
Definer: root@%
Modified: 2014-04-10 14:33:49
Created: 2014-04-10 14:33:49
Security_type: DEFINER
Comment:
character_set_client: latin1
collation_connection: latin1_swedish_ci
Database Collation: latin1_swedish_ci
1 row in set (0.00 sec)
mysql> show procedure status like 'GET_ALLBSG_COUNTERS';
+----------------+---------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+----------------+---------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| cudb_user_data | GET_ALLBSG_COUNTERS | PROCEDURE | root@% | 2014-04-10 14:33:49 | 2014-04-10 14:33:49 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci |
+----------------+---------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment