MySQL Commands

Connect to a MySQL server:

mysql -u username -p

Replace “username” with your MySQL username. You’ll be prompted for your MySQL password.

Show a list of all databases:

SHOW DATABASES;

Create a new database:

CREATE DATABASE database_name;

Replace “database_name” with the name you want to give your new database.

Use a database:

USE database_name;

Replace “database_name” with the name of the database you want to use.

Show a list of tables in the current database:

SHOW TABLES;

Create a new table:

CREATE TABLE table_name (
  column1 datatype,
  column2 datatype,
  column3 datatype,
  ...
);

Replace “table_name” with the name you want to give your new table, and replace “column1”, “column2”, “column3”, etc. with the names of the columns you want to create, and “datatype” with the data type for each column.

Insert data into a table:

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

Replace “table_name” with the name of the table you want to insert data into, and replace “column1”, “column2”, “column3”, etc. with the names of the columns you want to insert data into, and “value1”, “value2”, “value3”, etc. with the values you want to insert.

Select data from a table:

SELECT column1, column2, ... FROM table_name;

Replace “table_name” with the name of the table you want to select data from, and replace “column1”, “column2”, etc. with the names of the columns you want to select.

Update data in a table:

UPDATE table_name SET column1=value1, column2=value2, ... WHERE condition;

Replace “table_name” with the name of the table you want to update data in, and replace “column1”, “column2”, etc. with the names of the columns you want to update, and “value1”, “value2”, etc. with the new values you want to set. Replace “condition” with the condition that must be met for the update to take place.

Delete data from a table:

DELETE FROM table_name WHERE condition;

Replace “table_name” with the name of the table you want to delete data from, and replace “condition” with the condition that must be met for the delete to take place.

These are just some of the basic MySQL commands. There are many more advanced commands and variations of the commands listed here that you can use depending on your specific needs.