MySQL cheatsheet

[alirezaomidi]

Create database

create database [dbname];

Create user and grant access

create user '[user]'@'[host]' identified by '[pass]';
grant all privileges on dbname.* to '[user]'@'[host]';

Create a table

create table [dbname].[tablename] (
  field1 type1,
  filed2 type2
);

for this project:

create table fosscon.users (
  id int not null primary key auto_increment,
  email varchar(200),
  name varchar(200),
  phone varchar(20),
  stdnum varchar(7),
  workshop_num int,
  uniqid varchar(15)
);

Show tables

use [dbname];
show tables;