Execute SQL Script 

This operation execute a script as a single statement.

Features:

• The script can contain multiple statements.
• Statements can be of different types.
• No input or output parameters are accepted.

Create a project in anypoint studio and Configure the listener

Configure the Database connection

Drag and drop execute script from mule palette and configure the sql query text and provide the individual sql statement to execute

As a alternative you can also provide the sql script(.sql file) under Script Path rather then hardcoding the sql query

Deploy and test the application, table is created successfully and data is inserted in table