Access a MySQL database

版本 1.0.0.0 (20.6 KB) 作者: Dimitri Shvorob
(with mym.m)
4.0
(2)
7.1K 次下载
更新时间 2016/4/4

查看许可证

The submission collects several small utilities 'wrapping' Yannick Maret's 'mym' Matlab/MySQL interface, available from
http://sourceforge.net/projects/mym

Their application is illustrated by script mydemo.m, which uses the FEX download data presented in FEX submission 'A week on File Exchange'. First, we read the data (6 mixed-type columns, over 1 million rows) from a text file into a MySQL table, using 'load infile', passed through the basic mym interface. Next, we retrieve the table's structure and contents into Matlab workspace using TBATTR and TBREAD, and take the data back to MySQL with TBWRITE.

We observe that text-file-mediated exchange, accommodated on MySQL's side by 'load infile' and 'select into outfile', is a vastly superior option for large datasets; TBREAD and TBWRITE (the latter operating through multiple-row 'insert values' flushes) are more convenient for small datasets with many columns.

引用格式

Dimitri Shvorob (2024). Access a MySQL database (https://www.mathworks.com/matlabcentral/fileexchange/17897-access-a-mysql-database), MATLAB Central File Exchange. 检索时间: .

MATLAB 版本兼容性
创建方式 R2006a
兼容任何版本
平台兼容性
Windows macOS Linux
类别
在 Help Center 和 MATLAB Answers 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

mym utilities/

mym utilities/html/

版本 已发布 发行说明
1.0.0.0

BSD