mysql1_dart
mysql1_dart copied to clipboard
Question and thanks for your help
There is the possibility to implement like command or stored procedure
Like commando: ok.
_mysql = 'SELECT codart,desint,marart,modart FROM maeart WHERE desint LIKE ? LIMIT 2000'; descripcion = '%' + descripcion + '%'; List _parametros = [descripcion]; var results = await conn.query(_mysql, _parametros);
It worked this way.
String text1 = 'canal';
String text2 = '99.751.118-8';
text1 = '"' + text1 + '"';
text2 = '"' + text2 + '"';
_mysql = 'CALL maestros($text1,$text2)';
var _results = await conn.query(_mysql);
Mmmh... may be strings concatenation it's not secure? (see SQL Injection)