kevin3747118/note.md

## note.md

      
    Raw
  

              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