Help Center > > User Guide> MySQL Database Management (Standard Edition)> Function Management> Creating a Function

Creating a Function

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

Functions return the results of a specific action quickly. This section describes how to create a function.

  • You have obtained the CREATE ROUTINE permission.
  • You have obtained the Execute permission.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose Database Management. In the navigation pane on the left, choose Functions > Create Function.
  2. In the displayed dialog box, specify the required parameters and click OK. The page for editing the function is displayed.
  3. On the displayed tab, enter the SQL statements of the function and click Save.
  4. In the upper left corner of the SQL window, click Option. In the displayed Option dialog box, set required parameters and click OK.
  5. Save the new function or click Execute to invoke the object and view the status in the Message area.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel