In this tutorial first, we will create a table. To create a table, we have to understand data types. Here, the data types can be divided into three categories: Numeric, String, and Date-Time. If you want to create a table to store book information the SQL query can be written like the following:

The show tables command can be used to get a list of tables we have in this database. To get details about the attributes of the table, you can use desc table_name.

To alter the table you have created earlier, you can use alter table_name command. For example, if you want to add a new attribute for volume information, run the following command: