MySQL basic command (ii)

1. Show procedure status like ' stored procedure name '--queries the basic information of the stored procedure.
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7D/57/wKiom1bmXT7x9CUNAAAcQsD3QiU300.png "title=" 1.PNG " alt= "Wkiom1bmxt7x9cunaaacqsd3qiu300.png"/>

2. Show create procedure stored procedure name--specific definition of query stored procedure
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7D/57/wKiom1bmXeaSaF9DAAAgojWFN1M177.png "title=" 2.PNG " alt= "Wkiom1bmxeasaf9daaagojwfn1m177.png"/>

3. Select * FROM INFORMATION_SCHEMA. Routines where routine_name= ' stored procedure name '--you can also use this command to get more detailed information because all of the functions and stored procedure information is present in the Routines table.
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7D/57/wKiom1bmYjjAzBNxAAAl9xmShzY459.png "title=" 3.PNG " alt= "Wkiom1bmyjjazbnxaaal9xmshzy459.png"/>

4. Show triggers--queries all the trigger information in the database.
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7D/57/wKioL1bmfhOwFV-vAAAjbiElxvg038.png "title=" 4.PNG " alt= "Wkiol1bmfhowfv-vaaajbielxvg038.png"/>
5. Select * from information_schema.triggers where trigger_name= ' trigger name '--you can also use this command to get more detailed information, Because all the trigger information is present in the triggers table.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7D/59/wKiom1bmflTAroYTAABNdCFHn8E178.png "title=" 5.PNG " alt= "Wkiom1bmfltaroytaabndcfhn8e178.png"/>

6. SELECT @ @tx_isolation--View the isolation level of the database.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7D/5B/wKioL1bmtMqDBsH1AAAHol5N0ok599.png "title=" 6.PNG " alt= "Wkiol1bmtmqdbsh1aaahol5n0ok599.png"/>

This article is from the "Bronze Gong" blog, please be sure to keep this source http://jaeger.blog.51cto.com/11064196/1751041

MySQL basic command (ii)