Search code examples
mysqlinformation-schema

Can I create table in MySQL with adding columns in information_schema table directly

is there is opportunity create table by query to infirmation_schema without
create table ... ?
Thanks for answers.

Solution

  • without create table ...???

    Simple answer NO. Sole purpose of CREATE TABLE statement is to create a database table. In general CREATE Object statement are for creating DB objects. There is no other alternative way present for this unless you develop your own RDBMS product.

    In case you are confused, read Documentation and as it clearly says

    INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges.

    And yes it's Read-Only.