Show function definition in MySQL

Question

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.

dev.mysql.com/doc/refman/5.5/en/show-function-code.html

user330315
– user330315

2014-09-06 07:48:03 +00:00
Commented Sep 6, 2014 at 7:48 — user330315
– user330315, Commented Sep 6, 2014 at 7:48

Tuncay Göncüoğlu · Accepted Answer · 2014-09-06 07:04:05Z

14

SHOW CREATE FUNCTION float_convert

or

SHOW CREATE VIEW float_convert

perhaps ?

answered Sep 6, 2014 at 7:04

Tuncay Göncüoğlu

1,80718 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Super Kai - Kazuya Ito · Accepted Answer · 2023-11-24 23:15:03Z

You can show the CREATE FUNCTION statement with the SQL below. *The doc explains the SQL below and \G can show it more clearly and you must select a database when showing the CREATE FUNCTION statement otherwise there is the error:

SHOW CREATE FUNCTION <function_name>;

Or:

SHOW CREATE FUNCTION <function_name>\G

Collectives™ on Stack Overflow

Show function definition in MySQL

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related