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 个评论
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