MySQL Forums
Forum List  »  InnoDB

Re: MySQL create table in database information_schema
Posted by: Jon Stephens
Date: June 28, 2016 04:13AM

The only correct answer to your question is: Create your own database; create your own tables in the database that you've created.

There is NEVER any good reason for you to mess around in INFORMATION_SCHEMA or any other MySQL system database like you seem to want to do. Doing this kind of thing is 100% not supported.

So just don't do it--don't even try.

USE mytestdb;
CREATE TABLE test ... ;

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Written By
Re: MySQL create table in database information_schema
June 28, 2016 04:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.