Info

この質問は閉じられています。 編集または回答するには再度開いてください。

surpress output of MySQL connection function

1 回表示 (過去 30 日間)
Léon
Léon 2012 年 9 月 25 日
閉鎖済み: MATLAB Answer Bot 2021 年 8 月 20 日
Hello,
I'm wondering if I can surpress the output of my function:
function [reference, suspect] = sqldata( host,db,user,password,reference_tbl,suspect_tbl)
%%Create DB Connection
clear conn
conn = database(db, user, password, ...
'com.mysql.jdbc.Driver', ...
['jdbc:mysql://' host ':3306/' db]);
%%Fetch Data
setdbprefs('DataReturnFormat','cellarray');
e = exec(conn,['SELECT * FROM ' reference_tbl]);
e = fetch(e);
reference = e.Data;
e = exec(conn,['SELECT * FROM ' suspect_tbl]);
e = fetch(e);
suspect = e.Data;
end
using the ';' when using the function doesn't work however …
Help is greatly appreciated.
  2 件のコメント
Walter Roberson
Walter Roberson 2012 年 9 月 26 日
Which of the lines is producing the output ?
Léon
Léon 2012 年 9 月 26 日
I suppose reference = e.Data and suspect = e.data
I figured out that when I manually 'clear all' and run the function then everything is fine. When doing that twice in a row, then data doesn't seem to be fetched but output appears. Although I have 'clear all' in my script as well but is being ignored. Connection is closes as well using close(conn).

回答 (0 件)

この質問は閉じられています。

Community Treasure Hunt

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

Start Hunting!

Translated by