27.3.6 JavaScript SQL API

27.3.6.1 Session Object

27.3.6.2 SqlExecute Object

27.3.6.3 SqlResult Object

27.3.6.4 Column Object

27.3.6.5 Row Object

27.3.6.6 Warning Object

27.3.6.7 PreparedStatement Object

This section provides reference information for the SQL and result set API supported by JavaScript stored routines in the MLE Component.

The API supports the top-level objects listed here:

• Column: Result set column metadata.

• PreparedStatement: Handler for execution of prepared statements.

• Row: Row in a result set.

• Session: MySQL user session.

• SqlExecute: Handler for execution of (simple) SQL statements. Its execute() method executes an SQL statement.

• SqlResult: Result set returned by an SQL statement.

• Warning: Warning raised by statement execution.

The SQL API can be used only within JavaScript stored routines, and cannot be used within JavaScript stored functions.