MATLAB + DATABASE + MYSQL

最新推荐文章于 2024-05-01 16:32:41 发布

ykaitao

最新推荐文章于 2024-05-01 16:32:41 发布

阅读量422

点赞数

本文链接：https://blog.csdn.net/ykaitao/article/details/50407303

版权

Problem 1:

solution:

http://www.mathworks.com/matlabcentral/answers/97492-why-do-i-get-an-out-of-memory-error-when-i-use-the-fetch-function-in-database-toolbox-3-1-1-r2006a

Problem2:

Solution:

exec(conn, 'create table producttable (id INTEGER PRIMARY KEY, productNumber INTEGER,stockNumber INTEGER,supplierNumber INTEGER, unitCost REAL,productDescription TEXT)')

colnames = {'id', 'productNumber','stockNumber','supplierNumber',...
'unitCost','productDescription'}

coldata = {1, 11,800999,1006,9.00,'Toy Car'}

insert(conn,'productTable',colnames,coldata);

curs = exec(conn, 'select * from productTable');
curs = fetch(curs)

Result: