mysql "create table if not exists", determine if table created

Question

Is it possible to determine if a table was created or already existed when using create table if not exists...?

There seem to be two variables returned:

(query ok, affected_rows)

The query always returns (1, 0) regardless of if the table was created or already existed.

But it seems a create schema if not exists does return affected_rows=1.

Thanks.

you should specify what library or interface you are using to execute mysql queries to get better help — ysth
– ysth, Commented Jun 16, 2021 at 21:01
@ysth it is more about the MySQL protocol, and how it is inconsistent with affected_rows when creating schema vs creating tables. — zino
– zino, Commented Jun 16, 2021 at 21:22

the_nuts · Accepted Answer · 2021-06-16 20:59:02Z

3

I get 1 warning if the table exists (mysql 8.0.25):

mysql> CREATE TABLE IF NOT EXISTS `test` (`id` INT NOT NULL, PRIMARY KEY (`id`));
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE IF NOT EXISTS `test` (`id` INT NOT NULL, PRIMARY KEY (`id`));
Query OK, 0 rows affected, 1 warning (0.00 sec)

The warning is 1050 Table 'test' already exists

But you can just check if the table exists before creating it

answered Jun 16, 2021 at 20:59

the_nuts

6,1443 gold badges44 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql "create table if not exists", determine if table created

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related