Sql

PostgreSQL guide Connection Commands psql Definition: The PostgreSQL interactive terminal for connecting to a PostgreSQL database. Usage: 1 psql -h hostname -p port -U username -d database \connect (or \c) Definition: Connects to a new database and/or under a different user. Usage: 1 \\c database_name [username] \password Definition: Changes the password for the currently connected user. Usage: 1 \\password [username] \conninfo Definition: Displays information about the current database connection. ...

Sql documentation Installation The installation and usage of MySQL can be done in many ways; one is to install WAMP/XAMPP server and using SQL through it another is to use an online sql emulator, the best way is to use a MySQL server. Getting started with MySQL All the operations in SQL can be classified into 3 types DDL: Data definition language includes operation like create, alter, drop DML: Data manipulation language includes operation like select, insert, update, delete DCL: Data control language includes operations like commit, rollback, grant, revoke ...