How to delete a record from mysql database from matlab?
1 次查看(过去 30 天)
显示 更早的评论
This is my code which i'm using to delete a record of mysql databse from matlab, but it's giving an error........... plz let me know the correct code.........
-------------------------------------------------------------------------------------------
% --- Executes on button press in pushbutton1. function pushbutton1_Callback(hObject, eventdata, handles) % hObject handle to pushbutton1 (see GCBO) % eventdata reserved - to be defined in a future version of MATLAB % handles structure with handles and user data (see GUIDATA) conn=database('INVENTORY','root',''); p=get(handles.edit1,'string'); q=get(handles.edit2,'string');
columnnames = {'itemid','itemname'};
data = {p,q}; delete(conn,'additem',columnnames,data); exec(conn, 'DELETE FROM `additem` WHERE `itemid` = ''p''' ); curs = fetch(curs); curs.Data h=msgbox('DATA DELETED'); pause(2);
close(conn);
close(Additem);
Deleteitem
0 个评论
回答(1 个)
JohnGalt
2016-5-20
Use this (doesn't require the database toolbox): http://www.mathworks.com/matlabcentral/fileexchange/57195-niallhurley-mysql-matlab Then delete the record just using the appropriate SQL query - no need for other functions.
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!