Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
Updating MYSQL Table using MATLAB

Subject: Updating MYSQL Table using MATLAB

From: Hariprasad

Date: 17 Jun, 2013 13:17:10

Message: 1 of 1

Hi,
    I'm trying to update a table in mysql database using MATLAB. i have around 1.7 million records now in 1700 matfiles and the total data will grow beyond 4million.im only considering two columns of data and one table in mysql database. all data are numeric or double in MATLAB. i have been using update function of database toolbox and a set of 1000 rows takes around 6 minutes to update. i also tried using mysql.m
as given here : -

http://www.mathworks.in/matlabcentral/fileexchange/8663-mysql-database-connector

but it also takes almost the same amount of time. currently Im updating 1 row at a time.
Are there any faster methods to update a table?

Thanks

Tags for this Thread

No tags are associated with this thread.

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us