MYSQL Commands Cheat Sheet
Here is a cli commands cheat sheet for MYSQL command, you can use this as a quick reminder for basic commands with a brief description for each of the commands.
What is MYSQL command?
Add some data here
---
tags: [ database ]
---
# To connect to a database:
mysql -h -u -p
# To backup all databases:
mysqldump --all-databases --all-routines -u -p > ~/dump.sql
# To restore all databases:
mysql -u -p < ~/fulldump.sql
# To create a database in utf8 charset:
CREATE DATABASE owa CHARACTER SET utf8 COLLATE utf8_general_ci;
# To add a user and give rights on the given database:
GRANT ALL PRIVILEGES ON database.* TO 'user'@'localhost'IDENTIFIED BY 'password' WITH GRANT OPTION;
# To list the privileges granted to the account that you are using to connect to the server. Any of the 3 statements will work. :
SHOW GRANTS FOR CURRENT_USER();
SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER;
# Basic SELECT Statement:
SELECT * FROM tbl_name;
# Basic INSERT Statement:
INSERT INTO tbl_name (col1,col2) VALUES(15,col1*2);
# Basic UPDATE Statement:
UPDATE tbl_name SET col1 = "example";
# Basic DELETE Statement:
DELETE FROM tbl_name WHERE user = 'jcole';
# To check stored procedure:
SHOW PROCEDURE STATUS;
# To check stored function:
SHOW FUNCTION STATUS;
Check out the MYSQL command documentation .
You can also check our MegaSh cheatsheet tool, that has 150+ searchable linux cheat sheets in one page, so you never forget a command as you work again
Check Also
