SQL

Table of Contents

Sources of Information

How to articles

How to create nested SQL commands?

MySQL

How to execute a MySQL command in a shell script?

How to disable the foreign key checks?

mysql
SET FOREIGN_KEY_CHECKS=0;

(stackoverflow.com)

How to show a list of all data bases?

mysql

> show databases;

(cyberciti.biz)

How to set a password for the root user?

How to save and load database dumps?

GitHubImpressum