MySQL Basic Go Back Table queries views 06:47 You have to specify the name of the table that you want to create after CREATE TABLE Clause. This Table Name must be unique within the database. There are few optional clauses which can be used while creating table. [IF NOT EXISTS] is one such optional clause, which will check if table, which you are about to create is already present in the current database. If this clause is included and table with specified name is already present in active database, MySQL will ignore entire statement and will not create new table. This will avoid error. Introduction of RDBMS (Relative Database Management System) Installation and Administration of MYSQL MySQL Connection & Database queries Data types Table queries Inserting data and retrieving data Update query, like & where clauses Queries for sorting data