Here’s how my colleagues and I explain it to our students. It’s really not that difficult:
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 Fiddle
Think of jsFiddle, but then for databases: Create schemas and run queries on them. Microsoft SQL, MySQL, Oracle, and PostgreSQL supported.
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.
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!