MySQL Cheatsheet

MySQL Cheatsheet

Show all database

SHOW DATABASES

Create database

CREATE DATABASE XYZ

Show all tables

SHOW TABLES

Reset Tables with Foreign Keys

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table users;	# Truncate users table
SET FOREIGN_KEY_CHECKS = 1;

Original: Updated: