How to run large SQL statements on new lines
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Dan Howard
el 25 de Oct. de 2018
Respondida: Dan Howard
el 26 de Oct. de 2018
Good afternoon all...
Little questions regarding SQL statements in Matlab. I am currently using 2018 version and have produced a script that connects to a database and extracts data using a simple SQL statement.
I am trying to understand how you can tidy up the script by using larger SQL queries to extract more data by using a new line e.g ...
if true
% %Open the connection string- connect to Database
conn.Open(connection_string1);
SQL = 'select table.leg_no', ...
'from table');
end
This will only work if I place the whole statement on one line. I have tried [] and ().
Eventually I would like to create larger SQL queries that can be stored into variables to use in a GUI.
Really appreciate some help with this..Many thanks :-)
Please note: I am not running with the DataBase Toolbox.
0 comentarios
Respuesta aceptada
Guillaume
el 25 de Oct. de 2018
Editada: Guillaume
el 25 de Oct. de 2018
Your question is really about how to input a char vector using more than one line:
SQL = ['select table.leg_no ', ...
'from table ', ...
'where table.col1 = 12345'];
edit: don't forget the spaces as I did originally, matlab won't insert them between each line for you.
0 comentarios
Más respuestas (2)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!