sql.js

SQLite compiled to JavaScript through Emscripten

var db = SQL.open();
db.exec("CREATE TABLE my_table(a INTEGER, b INTEGER, c VARCHAR(100));");
db.exec("INSERT INTO my_table VALUES(1,13153,'thirteen thousand one hundred fifty three');");
db.exec("INSERT INTO my_table VALUES(1,987,'some other number');");
var data = db.exec("SELECT count(*) FROM my_table;");

sql.js demo →
sql.js source (GitHub) →

MySQL: Get next AUTO_INCREMENT value from/for table

Note to self: To get the next auto_increment value from a table run this query:

SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = "databaseName"
AND TABLE_NAME = "tableName"

Don’t forget it (again).

Did this help you out? Like what you see?
Consider donating.

I don’t run ads on my blog nor do I do this for profit. A donation however would always put a smile on my face though. Thanks!

☕️ Buy me a Coffee ($3)