Databases

Contents
Introduction
MySQL
PostgreSQL
MS SQL
Similar articles
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.
Banner image

Article author: Andrei Olegovich

Related articles
Databases
PostgreSQL
MySQL
MSSQL
SQLite3
MariaDB
NoSQL databases
SQL in general
Redis
MongoDB
MySQL + PHP
SQLite + Python

Search this site

Subscribe to Telegram channel @aofeed to follow new articles and updates to old ones

Go to channel

@aofeed

Ask a question in the Telegram group

@aofeedchat

Contacts and cooperation:
I recommend our hosting beget.com
Write to info@aredel.com if you:
1. Want to write an article for our site or translate an article into your native language.
2. Want to place thematically relevant ads on the site.
3. Ads on my site pass maximum censorship. If you see an ad block unsuitable for school-age children, shocking or misleading - please contact us by e-mail
4. Found a mistake, inaccuracy, bug, etc. on the site. ... .......
5. Articles can be shared on social media by clicking a network icon: