Re: MySQL create table in database information_schema
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.
CREATE DATABASE mytestdb;
USE mytestdb;
CREATE TABLE test ... ;
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle
Subject
Views
Written By
Posted
1931
June 28, 2016 02:20AM
Re: MySQL create table in database information_schema
946
June 28, 2016 04:13AM
866
June 28, 2016 04:57PM
784
June 28, 2016 06:04PM
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.