execute method
Executes a SQL query against the MySQL database connection. This is a low-level method that executes raw SQL queries. It handles exceptions and wraps results in a MySqlResult object for consistent error handling across the application. Parameters:
conn- The active MySQL database connectionsql- The SQL query string to execute Returns a MySqlResult containing either the query results or error information if the query failed. Example:
var result = await table.execute(conn, 'SELECT * FROM users');
if (result.success) {
print('Query executed successfully');
}
Implementation
Future<SqlDatabaseResult> execute(
DatabaseDriver conn,
Sqler sqler,
) async {
return conn.execute(sqler);
}