How to query and insert into mysql.
1 次查看(过去 30 天)
显示 更早的评论
According to my application, I need to copy some records from a table into another table in mysql. For example, I have two tables, t_imginfo and t_result. Both two tables have some structure.The primary key of t_imginfo is id. I want copy some records with specified .id into t_result. MY code is like
sqlquery = sprintf('insert into t_result (select * from t_imginfo where id = %d)',30);
curor = exec(conn, sqlquery);
curor = fetch(curor);
After the code is executed, nothing changed. What should I do to meet my requirement?
0 个评论
回答(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!