@gd,
To communicate with the Mysql database with Matlab, extract the data, and create a three-dimensional matrix, try these steps -
- Connect to the MySQL database - https://www.mathworks.com/help/database/ug/database.mysql.connection.html.
- Extract data from the database - Use the "sqlread" function to read data from a specific table. https://www.mathworks.com/help/database/ug/database.odbc.connection.sqlread.html.
- Create a 3D matrix - Assuming the output of "sqlread" is in a table format, use the "table2array" and "reshape" functions to convert the table to an array and reshape the array into a 3D matrix. https://www.mathworks.com/help/matlab/ref/table2array.html, https://www.mathworks.com/help/matlab/ref/double.reshape.html.
- Close the connection
Please check the links that I have shared after each step. They have explained how to perform the steps with explanation.
