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.

Table 1. MariaDB/MySQL, PostgreSQL and SQLite Client Cheat Sheet; Task ... The above trick also works as written in MariaDB and PostgreSQL as long as you change the bookid line of the CREATE TABLE ...

To others, however, the command line is too cumbersome to be efficient. Fortunately, for those users, there are plenty of GUIs available to make the task easier. One such GUI is MySQL Workbench .