how can i write delete query in matlab
显示 更早的评论
i try but it dos not work elete(conn, 'schduale', colnames1)
回答（2 个）
Oleg Komarov
2011-7-2
EDIT
Use:
curs = exec(conn,'delete query')
where delete query is one of the expression as indicated here http://www.w3schools.com/sql/sql_delete.asp
check if you queried correctly with:
curs.message
4 个评论
sayer ali
2011-7-2
Oleg Komarov
2011-7-2
What do you mean does not work, error message, unexpected result?
Oleg Komarov
2011-7-2
There's no delete all, unless all is a column
David Goldsmith
2012-5-4
I too was finding that this didn't work, and worse: it was "hard-locking" the DB such that I had to exit MATLAB in order to be able to access the DB again, even from w/in MATLAB! However, that was the clue, having remembered similar problems in the past, that eventually led me to the solution: chances are, sayer, (and anyone else who finds this 'cause you're having the same problem) that your DB has autocommit turned off (as it should be), so DB change operations (as opposed to merely query operations) needed to be committed before they "take," i.e., after your exec(conn, 'DELETE FROM table WHERE ...'), you must run commit(conn). So, for careful execution, I recommend code something like this:
curs = exec(conn, deleteStatement);
if isempty(curs.Message)
commit(conn)
:
else
rollback(conn)
:
end
close(curs)
Note that after any DB change operation (i.e., including update and fast/insert) you must call either commit or rollback to remove MATLAB's lock on the DB.
HTH,
DG
类别
在 帮助中心 和 File Exchange 中查找有关 Simulink Report Generator 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
