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 |
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | SQL | MBS SQL Plugin | 12.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
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 |
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-errno.html
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | SQL | MBS SQL Plugin | 12.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-field-count.html
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | SQL | MBS SQL Plugin | 12.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-info.html
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | SQL | MBS SQL Plugin | 12.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
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 |
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 |
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.