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