CODEWITHSUNDEEP
mysqlmysql-workbench
user3275044
user3275044

Reputation: 433

is it possible for exporting only functions in mysql workbench

Is it possible for exporting only the functions in MySQL workbench. Exporting is possible for stored procedure, but don't know how to export functions in MySQL workbench?

Upvotes: 2

Views: 18937

Answers (3)

Mohit Hapani
Mohit Hapani

Reputation: 59

  1. Click on Data export in the Management section on the left side.
  2. Select the schema (Dont select any tables)
  3. Check Dump Stored procedures and functions.
  4. Click Start Export.

This will dump only the procedures and function and no data.

Upvotes: 2

Alireza
Alireza

Reputation: 11

I had the problem and I solved it by opening the *.sql file via notepad and deleted the drop and create table queries.

Upvotes: 1

Mark
Mark

Reputation: 8431

You can export the create syntax function using the SHOW CREATE FUNCTION Syntax:

SHOW CREATE FUNCTION [func_name]

Or using the Forward Engineer Wizard(Ctrl+G)

enter image description here

Then select the MySQL Routine Objects to export functions:

enter image description here

Finally:

enter image description here

Upvotes: 4

Related Questions