mysql create database

MySQL create database

 

Create database

  mysql > create database name_of_database;
 

Select database:

  mysql > use name_of_database;
 

Create new table with columns:

  mysql > CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME);
 

Show all tables

  mysql > show tables;
 

Show table structure:

  mysql > describe [table];
 

Posted on Feb. 28, 2021, 1:24 p.m. in Database MySQL

Share: