connection
Description
Create a connection to a MySQL® database using the MySQL native interface. Configure a MySQL native interface data source using the databaseConnectionOptions
function. For details, see Configure MySQL Native Interface Data Source.
Creation
Create a connection
object by using the mysql
function.
Properties
DataSource
— Data source name
string scalar
This property is read-only.
Data source name, specified as a string scalar.
Example:
"MySQLDataSource"
Data Types: string
Database
— Database name
""
(default) | string scalar
This property is read-only.
Database name, specified as a string scalar.
If you use the 'DatabaseName'
name-value pair argument of the
mysql
function, the mysql
function sets the Database
property of the connection
object to the specified value.
Example:
"toystore_doc"
Data Types: string
Server
— Server name
localhost
(default) | string scalar
This property is read-only.
Server name, specified as a string scalar.
If you use the 'Server'
name-value pair argument of the mysql
function, the mysql
function sets the Server
property of the connection
object to the specified value.
Example:
"dbtb00"
Data Types: string
UserName
— User name
""
(default) | string scalar
This property is read-only.
User name, specified as a string scalar.
Data Types: string
DefaultCatalog
— Default catalog
""
(default) | string scalar
This property is read-only.
Default catalog, specified as a string scalar.
Example:
"toy_store"
Data Types: string
Catalogs
— Catalogs in database
""
(default) | string array
This property is read-only.
Catalogs in database, specified as a string array.
Example:
["information", "mysql"]
Data Types: string
Schemas
— Schemas in database
""
(default) | string array
This property is read-only.
Schemas in database, specified as a string array.
Example: ["information_schema", "toys"]
Data Types: string
AutoCommit
— Flag to autocommit transactions
string scalar
Flag to autocommit transactions, specified as one of these values:
"on"
— Database transactions are automatically committed to the database."off"
— Database transactions must be committed to the database manually.
You can set this property by using dot notation.
LoginTimeout
— Login timeout
0
(default) | positive numeric scalar
This property is read-only.
Login timeout, specified as a positive numeric scalar. The login timeout specifies the number of seconds that the driver waits while trying to connect to a database before throwing an error.
When no login timeout for the connection attempt is specified, the value is
0
.
When a login timeout is not supported by the database, the value is
-1
.
Data Types: double
MaxDatabaseConnections
— Maximum number of database connections
-1
(default) | positive numeric scalar
This property is read-only.
Maximum number of database connections, specified as a positive numeric scalar.
When the database has no upper limit to the maximum number of database connections,
the value is 0
.
When a maximum number of database connections is not supported by the database, the
value is -1
.
Data Types: double
DatabaseProductName
— Database product name
""
(default) | string scalar
This property is read-only.
Database product name, specified as a string scalar.
Example: "MySQL"
Data Types: string
DatabaseProductVersion
— Database product version
""
(default) | string scalar
This property is read-only.
Database product version, specified as a string scalar.
Example:
"5.7.22"
Data Types: string
DriverName
— Driver name
""
(default) | string scalar
This property is read-only.
Driver name of the MySQL driver, specified as a string scalar.
Example:
"Mariadb Connector/C"
Data Types: string
DriverVersion
— Driver version
""
(default) | string scalar
This property is read-only.
Driver version of the MySQL driver, specified as a string scalar.
Example:
"3.2.5"
Data Types: string
Object Functions
Manage MySQL Database Connection
Import Data from MySQL Database
sqlouterjoin | Outer join between two MySQL database tables |
sqlinnerjoin | Inner join between two MySQL database tables |
sqlfind | Find information about all table types in MySQL database |
sqlread | Import data into MATLAB from MySQL database table |
fetch | Import results of SQL statement in MySQL database into MATLAB |
executeSQLScript | Execute SQL script on MySQL database |
Export Data to MySQL Database
sqlwrite | Insert MATLAB data into MySQL database table |
Examples
Connect to MySQL Database Using MySQL Native Interface
Create a MySQL® native interface connection to a MySQL database. Then, import data from the database into MATLAB® and perform simple data analysis. Close the database connection.
This example assumes that you are connecting to a MySQL database using the MariaDB® C Connector driver.
Connect to the database using the data source name, user name, and password.
datasource = "MySQLNative"; username = "root"; password = "matlab"; conn = mysql(datasource,username,password)
conn = connection with properties: DataSource: "MySQLNative" UserName: "root" Database Properties: AutoCommit: "on" LoginTimeout: 0 MaxDatabaseConnections: 0 Catalog and Schema Information: DefaultCatalog: "toy_store" Catalogs: ["information_schema", "mysql", "performance_schema" ... and 3 more] Schemas: [] Database and Driver Information: DatabaseProductName: "MySQL" DatabaseProductVersion: "8.0.3-rc-log" DriverName: "Mariadb Connector/C" DriverVersion: "3.2.5"
The property sections of the connection
object are:
Database Properties
— Information about the database configurationCatalog and Schema Information
— Names of catalogs and schemas in the databaseDatabase and Driver Information
— Names and versions of the database and driver
Import all data from the table inventoryTable
into MATLAB using the sqlread
function. Display the first three rows of data.
tablename = "inventoryTable";
data = sqlread(conn,tablename);
head(data,3)
productNumber Quantity Price inventoryDate _____________ ________ _____ ____________________ 1 1700 15 23-Sep-2014 13:38:34 2 1200 9 09-Jul-2014 02:50:45 3 356 17 14-May-2014 11:14:28
Determine the highest product quantity from the table.
max(data.Quantity)
ans = 9000
Close the database connection conn
.
close(conn)
Version History
Introduced in R2020b
MATLAB コマンド
次の MATLAB コマンドに対応するリンクがクリックされました。
コマンドを MATLAB コマンド ウィンドウに入力して実行してください。Web ブラウザーは MATLAB コマンドをサポートしていません。
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)