link

Related

Insert Data

mysql

Insert data into tables

Execute SQL Query

psql

Run a SQL query from the terminal

Connect to MySQL

mysql

Connect to MySQL database

mysql/select

Select Data

Query data from tables

query
select
data

Command

SELECT

Explanation

Retrieve data from MySQL tables using SELECT statements.

Examples

Select all from table

SELECT * FROM users;

Select with condition

SELECT name, email FROM users WHERE age > 18;

Count records

SELECT COUNT(*) FROM users;

More

Show Databases

mysql

List all databases

Create Database

mysql

Create new database

Cleanup System

docker

Remove unused data