%% Execute Non-SELECT SQL Statement
% Using a relational database connection, create and execute a non-SELECT SQL statement that deletes a database table. The MySQLNative data source configures a database connection to a MySQL® database.
% This example uses a MySQL database version 5.7.22 database and the MySQL Connector/C++ driver version 8.0.15.
%
% Connect to the database using the data source name, user name, and password.

datasource = "MySQLNative";
username = "root";
password = "matlab";

conn = mysql(datasource,username,password);

%
% Load patient information into the MATLAB® workspace.

patients = readtable("patients.xls");

% Create the patients database table using the patient information.

tablename = "patients";
sqlwrite(conn,tablename,patients)

%
% Import the data from the patients database table.

data = sqlread(conn,tablename);

%
% Delete the patients database table using the execute function.

sqlquery = strcat("DROP TABLE ",tablename);
execute(conn,sqlquery)

%
% Ensure that the table no longer exists.

data = sqlfind(conn,tablename)

%
% Close the database connection.

close(conn)

% Copyright 2020 The MathWorks, Inc.