@azhou/mysql-wrapper

MySQL simplified wrapper

Usage no npm install needed!

<script type="module">
  import azhouMysqlWrapper from 'https://cdn.skypack.dev/@azhou/mysql-wrapper';
</script>

README

Usage

  1. Initialize database

    var db = require("@azhou/mysql-wrapper");
db.init("server", "database", "username", "password");

  2. Run queries

    Promise is returned as query gets executed

    • General query

      db.query(sql).then(function (result) {
    // process results
}.catch(function (error) {
    // process error
});

    • Return single row

      db.queryFirstRow("SELECT * FROM record WHERE id=?", id).then(...);

    • Return single value:

      db.queryFirstField("SELECT COUNT(*) FROM record").then(...);