MySQL Forums
Forum List  »  Newbie

Re: MySQL Dump commands fails
Posted by: Muhammad Ali
Date: May 01, 2015 04:23AM

Thanks for continued support. Please find below values of all the columns of the table except columns containing the code.

mysql> SELECT SPECIFIC_NAME,
-> ROUTINE_CATALOG,
-> ROUTINE_SCHEMA,
-> ROUTINE_NAME,
-> ROUTINE_TYPE,
-> DATA_TYPE,
-> CHARACTER_MAXIMUM_LENGTH,
-> CHARACTER_OCTET_LENGTH,
-> NUMERIC_PRECISION ,
-> NUMERIC_SCALE,
-> DATETIME_PRECISION,
-> CHARACTER_SET_NAME,
-> COLLATION_NAME,
-> DTD_IDENTIFIER
-> EXTERNAL_LANGUAGE,
-> PARAMETER_STYLE,
-> IS_DETERMINISTIC,
-> SQL_DATA_ACCESS,
-> SQL_PATH,
-> SECURITY_TYPE,
-> CREATED,
-> LAST_ALTERED,
-> SQL_MODE ,
-> ROUTINE_COMMENT ,
-> DEFINER,
-> CHARACTER_SET_CLIENT,
-> COLLATION_CONNECTION,
-> DATABASE_COLLATION
-> FROM information_schema.ROUTINES WHERE ROUTINE_NAME='Test_CustomerInfo';
+--------------------------+-----------------+----------------+--------------------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+------------------------+-----------------+-------------------+----------------------+----------------------+--------------------+
| SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE | ROUTINE_COMMENT | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION |
+--------------------------+-----------------+----------------+--------------------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+------------------------+-----------------+-------------------+----------------------+----------------------+--------------------+
| Test_CustomerInfo | def | PoS | Test_CustomerInfo | PROCEDURE | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL | NO | CONTAINS SQL | NULL | INVOKER | 2014-12-10 17:43:01 | 2014-12-10 17:43:01 | NO_ENGINE_SUBSTITUTION | | root@10.16.25.75| utf8 | utf8_general_ci | utf8_general_ci |
+--------------------------+-----------------+----------------+--------------------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+------------------------+-----------------+-------------------+----------------------+----------------------+--------------------+

Options: ReplyQuote


Subject
Written By
Posted
April 18, 2015 08:45AM
April 21, 2015 05:00PM
April 22, 2015 11:25PM
April 25, 2015 10:47PM
April 29, 2015 06:25PM
Re: MySQL Dump commands fails
May 01, 2015 04:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.