Search code examples
sqlmysqldatabasesql-functionmysql-function

Show function definition in MySQL

I am working with existing project, and I am found a sql query with sql-function like

SELECT * FROM money WHERE  amount = float_convert(0.1);

This Query is Working Properly, But I want to see and edit the function float_convert().

I am already tried SHOW FUNCTION STATUS;.

It's only showing functions status, I need to view the function definition.

Solution 
  • SHOW CREATE FUNCTION float_convert

    or

    SHOW CREATE VIEW float_convert

    perhaps ?