Info

Questa domanda è chiusa. Riaprila per modificarla o per rispondere.

surpress output of MySQL connection function

1 visualizzazione (ultimi 30 giorni)
Léon
Léon il 25 Set 2012
Chiuso: MATLAB Answer Bot il 20 Ago 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 Commenti
Walter Roberson
Walter Roberson il 26 Set 2012
Which of the lines is producing the output ?
Léon
Léon il 26 Set 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).

Risposte (0)

Questa domanda è chiusa.

Community Treasure Hunt

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

Start Hunting!

Translated by