What is the correct way to write an IF condition to create a table and add its indexes if it doesn't already exist?

Question

SQL

It is necessary to check for the existence of the table and if the table does not exist, then create it and add several indexes. A simple problem, but I constantly catch some errors and have no idea how to solve them. Of course, you can do everything through PHP with separate queries, but I would like 1 SQL query.

Answer 1

CREATE TABLE IF NOT EXISTS ...