surpress output of MySQL connection function

1 次查看（过去 30 天）

显示更早的评论

Léon 2012-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49093-surpress-output-of-mysql-connection-function

关闭： MATLAB Answer Bot 2021-8-20

在 MATLAB Online 中打开

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 2012-9-26

Which of the lines is producing the output ?

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).

此问题已关闭。