Io Reference







Databases   /   MySQL   /   MySQL





MySQL is a fast, multi-threaded, multi-user SQL database server. IoMySQL is a MySQL binding for Io, by Min-hee Hong.

my := MySQL establish("localhost", "user", "password", "database")

# Get rows by Map
my queryThenMap("SELECT * FROM rel") foreach(at("col") println)
# Get rows by List
my query("SELECT * FROM rel") foreach(at(0) println)

my close
 
 
 



close

Closes a previously opened connection.
connect(host, user, password, database, port, unixSocket, useSSL)

Connect to a MySQL database.
connected

Returns true if connected to the database, false otherwise.
establish

Establish a connection to a MySQL database.
lastInsertRowId

Returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement.
query(aQueryString)

Perform a SQL query and return a list of results.
	db query("SELECT * FROM accounts") foreach(println)