MySQL and mSQL

Name

Method: connection.do( )

Signature

results = connection.do(sql)

Synopsis

Sends the specified SQL statement to the currently selected database for execution. The results are returned as a list of lists where each list represents a single row. The method is also used for updates—you just do not process the return value.

Example

results = conn.do(`SELECT title, year FROM movies');
row1 = results[0];