Databases

MySQL
How to Rename a MySQL Table
How to Add a Column to MySQL Table
How to add a row to the database table
How to delete a row in the database table
How to change the value in the MySQL table
How to find all tables with a certain column
How to access the database within the site
Examples of scripts
PostgreSQL
Main article
Installation
\l: List of existing OBD
Creation of OBD
Delete the database
Coding verification
\c: Go to DB
Connection to OBD
Users
Tables:
\dt: List of tables
\d name of table: Composition of the table
Change of the table
Bash scripts:
PostgreSQL script from Bash
Starting a script from a file
Import from .csv file
Depart from PostgreSQL Console
Find out the current scheme
System variables
SELECT
WHERE
postgresql.conf: Configuration file
Replication of master slave
Write Ahead Log
recovery.conf
pg_hba.conf
Help
Mistakes.
EnterpriseDB
MSSQL
MS SQL
Mistakes.

Article author: Andrei Olegovich

Banner image