Info

This question is closed. Reopen it to edit or answer.

surpress output of MySQL connection function

1 view (last 30 days)
Léon
Léon on 25 Sep 2012
Closed: MATLAB Answer Bot on 20 Aug 2021
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 Comments
Walter Roberson
Walter Roberson on 26 Sep 2012
Which of the lines is producing the output ?
Léon
Léon on 26 Sep 2012
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).

Answers (0)

This question is closed.

Community Treasure Hunt

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

Start Hunting!