[日本語]

This is a memo of SQL commands which I learned from workplace and self-study.

If you do not know SQL, please refer to “Database, DBMS and SQL“. Here, SQL commands are classified as follows.

・DDL

・DML

・DCL

・Others

• List and Description of SQL Commands

※Checked operation with MySQL

– Display a list of databases

SHOW DATABASES;

– Changing database

USE database_name;

– Show list of tables

SHOW TABLES;

– Show table definition

DESC table_name;

• Manual

– MySQL

– PostgeSQL

• Memo

– pgAdmin (PostgreSQL) command memo

—–Problem1—–
ERROR: relation “table name” does not exist

—–Solution1—–

SHOW search_path;
SET search_path TO （Schema_name）;

20190701