Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

IHK SQL Cheat Sheet (DRAFT) by

IHK-Relevant SQL-Commands

This is a draft cheat sheet. It is a work in progress and is not finished yet.

DML

bar
baz
trei
baum
haus
nope
  

DDL

CREATE DATABASE IF NOT EXISTS db ;
ZXC
SHOW FIELDS FROM <Ta­bel­len­nam­e>;
 

DCL

CREATE USER 'usr'@'%' IDENTIFIED BY  'pas';
 
GRANT USAGE ON . TO 'usr'@'%';
 
GRANT ALL PRIVILEGES ON db . * TO 'usr'­­@'%';
oda so:


CREATE USER 'dbot'@'%' IDENTIFIED BY '*';

GRANT USAGE ON . TO 'dbot'@'%' IDENTIFIED BY '*' WITH MAX_QU­ERI­ES_­PER­_HOUR 0 MAX_CO­NNE­CTI­ONS­_PE­R_HOUR 0 MAX_UP­DAT­ES_­PER­_HOUR 0 MAX_US­ER_­CON­NEC­TIONS 0 ;

CREATE DATABASE IF NOT EXISTS 
dbot
;

GRANT ALL PRIVILEGES ON 
dbot
. * TO 'dbot'­@'%';