insertData method

Future insertData(
  1. String tableName,
  2. Map<String, dynamic> fields
)

Implementation

Future insertData(String tableName, Map<String,dynamic >fields) async {
  var result = await mySqlConnection?.query(
      'insert into $tableName (${fields.entries.map((entry) => '${entry.key}').join(',')}) values (${fields.entries.map((entry) => '?').join(',')})',
      //'insert into users (name, email, age) values (?, ?, ?)',
      // ['Bob', 'bob@bob.com', 25]
      [fields.entries.map((entry) => '${entry.value}').join(',')]);
  print('Inserted row id=${result?.insertId}');
}