Mysql/CheatSheet

From Wiki
< Mysql
Revision as of 14:07, 10 June 2020 by Marcluer (talk | contribs)

Databases

  • Create
CREATE DATABASE [IF NOT EXISTS] database_name;
  • Use
USE database_name;
  • Delete
DROP DATABASE [IF EXISTS] database_name;
  • List all
SHOW DATABASE;


Tables

  • list
SHOW TABLES;
  • create
CREATE TABLE [IF NOT EXISTS] table_name(
  column_list
);



other