How to delete a record from mysql database from matlab?

1 view (last 30 days)
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

Answers (1)

JohnGalt
JohnGalt on 20 May 2016
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.

Tags

Community Treasure Hunt

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

Start Hunting!