When you insert new records into an SQL database, ... Form your initial insertion query, such as "INSERT INTO your_table ... MySQL: Insert ...

And that’s all there is to creating a table and inserting data into it on MySQL. Once you have all the data necessary, your database is ready for usage by your web-based tool.

So for SQLite, change the bookid line in the CREATE TABLE statement above to this: bookid integer PRIMARY KEY, And, SQLite3 will create a table with equivalent settings to MariaDB and PostgreSQL. The ...