insert data in mysql

6 次查看（过去 30 天）
Siti Maisarah
Siti Maisarah 2011-4-13
hi..I want to insert data from the text box in gui to mysql database.. I was referring this tutorial, http://www.mathworks.com/help/toolbox/database/gs/bq9nzkl-1.html but at there, it already declare the data that want to insert. here the coding ->export_data = {'07-Aug-2003',50.44};
but if the data is insert by the user in gui, how? thanks

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2011-4-13
Look at the GUI in step 8 of that tutorial, and see there the MATLAB Command. That command was generated based upon the other inputs, and is the command that would be executed in a MATLAB function in order to insert those values.
It appears the format is
insert(conn, TableNameString, FieldNamesCellStr, FieldValuesCell)
It doesn't matter to MATLAB whether you hard-code the FieldValuesCell or if you assign the cell to a variable and pass that, or if you build up the cell by get()'ing values from a user interface.
  1 个评论
Siti Maisarah
Siti Maisarah 2011-4-15
ok..i got it..one more thing, how to connect the query that we have made with the button in gui..for example, button insert..i really new in matlab.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by