MySQL Note

note.md

MySQL

DDL

Enable root remote login :

  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

  FLUSH PRIVILEGES;

Modify db max connections :

  show variables like ‘max_connections’;

  Set global max_connections = xxxx;

Disable safe mode :

  show variables like '%safe_updates%';

  SET SQL_SAFE_UPDATES = 0;

Show connections :

  Show status like ‘%onn%’;

DML

MySQL Insert Select :

  insert into alzk.keyareas (areaid, keyid, timecontrol, passed) select distinct areaid, 'aa000123456789', '[]', 'N' from alzk.keyareas