Update 常用操作.md

StackJonSnow · web-flow · commit 2ad0fc526d99 · 2024-07-09T17:38:14.000+08:00
diff --git a/database/MySQL/&#24120;&#29992;&#25805;&#20316;.md b/database/MySQL/&#24120;&#29992;&#25805;&#20316;.md
@@ -76,3 +76,19 @@ mysqlimport -u root -p --local database_name dump.txt
 ```
 ALTER TABLE test002.test_data002 ADD INDEX index_type (type) , ALGORITHM=INPLACE, LOCK=NONE;
 ```
+
+### &#23548;&#20986;&#25968;&#25454;&#21040;&#25991;&#20214;
+```
+mysql -h${host} -u${user} --password=${password} --database=${db_name} --execute="select ${col1} AS '${col1_name}',case when(${col2}=1) then '${col2_name1}' else '${col2_name2}' end as '${col2_alias_name}' from ${table}" -X > /${dir}/${file}.xlsx
+```
+
+### &#21019;&#24314;&#29992;&#25143;
+```
+CREATE USER 'username'@'host' IDENTIFIED BY 'password';
+```
+
+### &#25480;&#20104;&#26435;&#38480;
+```
+GRANT SELECT ON *.* TO 'readonly'@'%' IDENTIFIED BY '${password}';
+GRANT SELECT ON *.* TO 'readonly'@'%';
+```
