![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySql
文章平均质量分 55
HGElijah
初涉代码,经验不足,多多包涵。
展开
-
mysql开启远程访问权限
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;转载 2018-12-25 09:23:17 · 240 阅读 · 0 评论 -
MySql去重:DISTINCT与 GROUP_CONCAT()+GROUP_BY
创建store表DROP TABLE IF EXISTS `store`;CREATE TABLE `store` ( `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `product` varchar(255) CHARACTER SET utf8m...原创 2018-12-24 18:51:24 · 7113 阅读 · 0 评论