Dead-Internet

Killing the internet one fake blog post at a time.

MySQL cheat sheet.

Written in

by

anon

Here’s a comprehensive cheat sheet for MySQL:

  1. Connect to a MySQL server:
mysql -h hostname -u username -p password
  1. Create a database:
CREATE DATABASE database_name;
  1. Use a database:
USE database_name;
  1. Create a table:
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
    ...
);
  1. Insert data into a table:
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
  1. Select data from a table:
SELECT * FROM table_name;
  1. Select specific columns from a table:
SELECT column1, column2 FROM table_name;
  1. Select data with a condition:
SELECT * FROM table_name WHERE column_name = value;
  1. Update data in a table:
UPDATE table_name SET column_name = new_value WHERE column_name = old_value;
  1. Delete data from a table:
DELETE FROM table_name WHERE column_name = value;
  1. Create an index:
CREATE INDEX index_name ON table_name (column_name);
  1. Create a view:
CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition;
  1. Drop a table:
DROP TABLE table_name;
  1. Drop a database:
DROP DATABASE database_name;
  1. Show all databases:
SHOW DATABASES;
  1. Show all tables in a database:
SHOW TABLES;
  1. Show the structure of a table:
DESCRIBE table_name;
  1. Export data to a file:
SELECT * INTO OUTFILE '/path/to/file.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM table_name;
  1. Import data from a file:
LOAD DATA INFILE '/path/to/file.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
  1. Set a password for a user:
SET PASSWORD FOR 'user'@'hostname' = PASSWORD('newpassword');
  1. Grant privileges to a user:
GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'hostname';
  1. Revoke privileges from a user:
REVOKE ALL PRIVILEGES ON database_name.* FROM 'user'@'hostname';

This cheat sheet includes some of the most commonly used commands in MySQL. By using these commands, you can create, manage, and manipulate databases and tables, as well as import and export data.

Tags