Cacher is the code snippet organizer for pro developers

System Shell

Database Management

1. Export Data

mysqldump -u username -p dbname > dbexport.sql 
mysqldump -p username -o dbname tableName > tableName.sql

1. Import Data

mysql -u username -p dbname < dbexport.sql

MySQL Shell

User Management

1. Create New User

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

1. Update Password

MySQL 5.7.6 and later:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

MySQL 5.7.5 and earlier:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

Table Management

1. Add

   -- copy and insert row from same table
   CREATE TEMPORARY TABLE tmptable_1 SELECT * FROM table WHERE primarykey = 1;
   UPDATE tmptable_1 SET primarykey = NULL;
   INSERT INTO table SELECT * FROM tmptable_1;
   -- !!! need check before drop
   DROP TEMPORARY TABLE IF EXISTS tmptable_1;
   

2. Read

   select *
   from INFORMATION_SCHEMA.TABLE_CONSTRAINTS
   where CONSTRAINT_TYPE = 'FOREIGN KEY'
   
   -- display all view tables
   SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';
   

3. Update

   UPDATE
       Sales_Import SI,
       RetrieveAccountNumber RAN
   SET
       SI.AccountNumber = RAN.AccountNumber
   WHERE
       SI.LeadID = RAN.LeadID;
   

Cell Management

1. Using field value to fill cell data

   Update goods Set thumb_image = concat('xxx/image/', goods_id, '.jpg')
   

Comments

SELECT table_comment 
    FROM INFORMATION_SCHEMA.TABLES 
    WHERE table_schema='my_cool_database' 
        AND table_name='user_skill';

Config

一般是通过 my.ini 或者 my.cnf 文件来修改的(my.ini 和 my.cnf 并没有什么区别)

配置	说明	例子
lc-messages	信息提示本地化设置	lc-messages = 'en_US'