Platforms to show: All Mac Windows Linux Cross-Platform

Back to MySQLMBS class.

MySQLMBS.AffectedRows as UInt64

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Queries the number of affected rows in the last statement.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html

MySQLMBS.Error as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Queries the last error text.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-error.html

MySQLMBS.ErrorNumber as UInt32

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Queries the last error code.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-errno.html

MySQLMBS.FieldCount as UInt32

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the number of columns for the most recent query on the connection.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-field-count.html

MySQLMBS.Info as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Retrieves an info string providing information about the most recently executed statement.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-info.html

MySQLMBS.InsertID as Int64

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the last auto increment value from last insert command.

Please query value right after doing Insert. This value is reset when you call commit.
For mySQL and MariaDB connections.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-insert-id.html

MySQLMBS.NumberOfRows(cmd as SQLCommandMBS) as UInt64

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Queries number of records in a command.

MySQLMBS.SetSSL(keyPath as string, CertificatePath as string, AuthorityPath as string, authorityFolderPath as string, Cipher as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 12.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Sets SSL connection parameters.

Calls mysql_ssl_set internally.
Used for establishing secure connections using SSL. It must be called before Connect(). It does nothing unless SSL support is enabled in the client library.

keyPath is the path name to the key file.
CertificatePath is the path name to the certificate file.
AuthorityPath is the path name to the certificate authority file.
authorityFolderPath is the path name to a directory that contains trusted SSL CA certificates in PEM format.
Cipher is a list of permissible ciphers to use for SSL encryption.

Any unused SSL parameters may be given as empty string.
For paths, please use folderitem.NativePath and not folderitem.ShellPath.

Please switch to using the following options on the connection:

MYSQL_SSL_KEY
MYSQL_SSL_CERT
MYSQL_SSL_CA
MYSQL_SSL_CAPATH
MYSQL_SSL_CIPHER

They should be specified before the connection is made.
e.g.

db.Option("MYSQL_SSL_CIPHER") = "DHE-RSA-AES256-SHA"

Allows to specify MySQL SSL parameters that will be used with mysql_ssl_set. MySQL API method called only when at least one parameter specified. See MySQL documentation for more information about these options.

The items on this page are in the following plugins: MBS SQL Plugin.


The biggest plugin in space...