SQL Statement

Official Statements

Ref: https://dev.mysql.com/doc/refman/8.0/en/sql-statements.html

Common SQLs

DESC tabl_name;
CREATE INDEX idx_price_release ON stock(price,released_at);
DROP INDEX price ON stock;
SHOW INDEX FROM stock;

Funcs

SELECT * FROM goods_order WHERE RIGHT(id,1) IN (1,2,3);

Account

MySQL 账户操作：

--  8.0 本地连接账户失败
ALTER USER 'remote'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxx';
-- 权限设置 ON *.* 
GRANT all privileges on `dbname`.* to 'newuser'@'%' identified by 'password';

ALTER TABLE

ALTER TABLE contacts
  ADD last_name varchar(40) NOT NULL
    AFTER contact_id;