mysql1_ext 0.0.4

A library for connecting to and querying MySQL & MariaDB databases.

example/example.dart

import 'dart:async';

import 'package:mysql1_ext/mysql1_ext.dart';

Future<void> main() async {
  // Open a connection (testdb should already exist)
  final conn = await MySqlConnection.connect(
    ConnectionSettings(
      user: 'root',
      db: 'testdb',
      password: 'secret',
    ),
  );

  // Create a table
  await conn.query(
    'CREATE TABLE users (id int NOT NULL AUTO_INCREMENT PRIMARY KEY, '
    'name varchar(255), email varchar(255), age int)',
  );

  // Insert some data
  final result = await conn.query(
    'insert into users (name, email, age) values (?, ?, ?)',
    ['Bob', '[e-mail]', 25],
  );
  print('Inserted row id=${result.insertId}');

  // Query the database using a parameterized query
  final results = await conn.query(
    'select name, email, age from users where id = ?',
    [result.insertId],
  );
  for (final row in results) {
    print('Name: ${row[0]}, email: ${row[1]} age: ${row[2]}');
  }

  // Update some data
  await conn.query('update users set age=? where name=?', [26, 'Bob']);

  // Query again database using a parameterized query
  final results2 = await conn.query(
    'select name, email, age from users where id = ?',
    [result.insertId],
  );
  for (final row in results2) {
    print('Name: ${row[0]}, email: ${row[1]} age: ${row[2]}');
  }

  // Finally, close the connection
  await conn.close();
}