Data in SQLite databases is stored in tables.
A table has columns with headings. Items are stored in these
tables as rows, sometimes called records.
This model also applies to MySQL, MariaDB and PostgreSQL
You may like:
Learning SQL: Master SQL Fundamentals
Connect to your database with the command
where database.db is your existing database.
Surprise, create a table with the SQL query
The database system needs to know the column names.
CREATE TABLE EMPLOYEE(
The table has four columns: id, name, education, salary.
How does the database know what kind of data can be inside the cells? we define that (TEXT, REAL)
You can create as many tables as you want.
Got tables? Now you can insert data.
Every database can have tables. To view the tables you have use the SQL query:
That will show you a list of all tables.
Video demonstration on database table creation below: