Data Definition Language

CREATE

CREATE DATABASE IF NOT EXISTS registradoDB
	CHARACTER SET = charset_name
	COLLATE = collation_name
	ENCRYPTION = 'Y';

CREATE EVENT IF NOT EXISTS event_name
	ON SCHEDULE EVERY DAY
	ON COMPLETION PRESERVE
	ENABLE
	COMMENT ''
	DO
	event_body;

CREATE FUNCTION IF NOT EXISTS sp_name ([func_parameter[,...]])
	RETURNS type [characteristic ...] routine_body;

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name
	USING BTREE ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...;

CREATE LOGFILE GROUP logfile_group
	ADD UNDOFILE 'undo_file'
	INITIAL_SIZE = initial_size
	UNDO_BUFFER_SIZE = undo_buffer_size
	REDO_BUFFER_SIZE = redo_buffer_size
	NODEGROUP = nodegroup_id
	WAIT COMMENT = 'string'
	ENGINE = engine_name;

CREATE PROCEDURE IF NOT EXISTS sp_name ([proc_parameter[,...]])
	[characteristic ...]
	routine_body;

CREATE SERVER server_name
	FOREIGN DATA WRAPPER wrapper_name
	OPTIONS (USER 'Remote', HOST '198.51.100.106', DATABASE 'test');

CREATE SPATIAL REFERENCE SYSTEM IF NOT EXISTS 4120
	NAME 'srs_name'
	DEFINITION 'definition'
	ORGANIZATION 'org_name'
	IDENTIFIED BY org_id
	DESCRIPTION 'description';

CREATE TABLE table (id NOT NULL AUTO_INCREMENT, name varchar(255), description varchar(255), PRIMARY KEY (id))
	TABLESPACE tablespace_name
	ROW_FORMAT=COMPRESSED
	KEY_BLOCK_SIZE=8;

CREATE TABLESPACE tablespace_name
	ADD DATAFILE 'ts1.ibd'
	FILE_BLOCK_SIZE = 8192
	ENGINE=INNODB;

CREATE TRIGGER IF NOT EXISTS trigger_name
	AFTER INSERT ON tbl_name
	FOR EACH ROW FOLLOWS other_trigger_name;

CREATE VIEW table_view [(column_list)] AS
	select_statement WITH CASCADED CHECK OPTION;

CREATE ROLE IF NOT EXISTS 'webapp'@'localhost'

CREATE USER IF NOT EXISTS 'michel'@'localhost'
  	IDENTIFIED WITH caching_sha2_password BY 'new_password'
  	PASSWORD EXPIRE INTERVAL 180 DAY
  	FAILED_LOGIN_ATTEMPTS 3
  	PASSWORD_LOCK_TIME 2;
	

DROP

DROP DATABASE IF EXISTS db_name;

DROP EVENT IF EXISTS event_name;

DROP FUNCTION IF EXISTS sp_name;

DROP INDEX index_name ON tbl_name [algorithm_option | lock_option] ...;

DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name;

DROP PROCEDURE IF EXISTS sp_name;

DROP SERVER IF EXISTS server_name;

DROP SPATIAL REFERENCE SYSTEM IF EXISTS srid;

DROP TABLE IF EXISTS tbl_name [, tbl_name] ... [RESTRICT | CASCADE];

DROP TABLESPACE tablespace_name;

DROP TRIGGER IF EXISTS [schema_name.]trigger_name;

DROP VIEW IF EXISTS] view_name [, view_name] ... [RESTRICT | CASCADE];

DROP ROLE IF EXISTS 'webapp'@'localhost';

DROP USER IF EXISTS 'michel'@'localhost';
	

ALTER

ALTER DATABASE db_name alter_option ...;

ALTER EVENT event_name
	[ON SCHEDULE schedule]
	[ON COMPLETION [NOT] PRESERVE]
	[RENAME TO new_event_name]
	[ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}]
	[COMMENT 'string']
	[DO event_body];

ALTER FUNCTION func_name [characteristic ...];

ALTER INSTANCE instance_action;

ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name;

ALTER PROCEDURE proc_name [characteristic ...];

ALTER SERVER server_name OPTIONS (option [, option] ...);

ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options];

ALTER TABLESPACE tablespace_name;

ALTER VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION];
	

TRUNCATE

TRUNCATE [TABLE] tbl_name;
	

Data Query Language

SELECT

SELECT t.id FROM table AS t
WHERE t.id = 1
GROUP BY t.type
ORDER BY t.id ASC
LIMIT 1 OFFSET 0;
	

Data Manipulation Language

INSERT

INSERT INTO `table` (name, description)
VALUES
	('name1', 'desc1'),
	('name2', 'desc2');
	

UPDATE

UPDATE table SET name = '', description = '' WHERE table.id = 1;
	

DELETE

DELETE FROM table_name WHERE condition;
	

Data Control Language

GRANT

GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT 'role1', 'role2' TO 'user1'@'localhost', 'user2'@'localhost';
GRANT SELECT ON world.* TO 'role3';
	

REVOKE

REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost';
REVOKE 'role1', 'role2' FROM 'user1'@'localhost', 'user2'@'localhost';
REVOKE SELECT ON world.* FROM 'role3';
	

Transaction Control Language

COMMIT

START TRANSACTION;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summary=@A WHERE type=1;
COMMIT;
	

ROLLBACK

START TRANSACTION;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summary=@A WHERE type=1;
ROLLBACK;
	

SAVE POINT

SAVEPOINT identifier
ROLLBACK [WORK] TO [SAVEPOINT] identifier
RELEASE SAVEPOINT identifier