- 博客(4)
- 资源 (6)
- 收藏
- 关注
原创 mysql 导出 导入测试
SELECT * INTO OUTFILE '/tmp/cfg_devicetype.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'FROM lte.cfg_devicetype; SELECT * INTO OUTFILE '/tmp/cfg
2015-06-22 17:57:28 457
原创 mysql新增用户
新增用户分为3步骤1.root 登陆mysql -uroot -p 2. 查看数据库mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || perfo
2015-06-11 00:56:42 644
原创 mysql密码丢失 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
密码丢失修改密码mysql> use mysqlERROR 1820 (HY000): You must SET PASSWORD before executing this statementmysql> exitBye[root@localhost ~]# /etc/init.d/mysql stop ERROR! MySQL server process #17602 is n
2015-06-10 21:17:53 2191
原创 impala优化--简单篇(一)
查询太慢,这个和oracle不同,但是也有统计信息,执行计划。[SLAVE02:21000] > show table stats preparation.P_USERLIST_1409;Query: show table stats preparation.P_USERLIST_1409+-------+--------+----------+--------------+-------
2015-06-04 23:18:22 2427
springboot+springmvc+cloud+mysql+durid+eureka+rabbit+bootstrap+jquery+css
2018-08-04
sqluldr2的介绍与应用
2012-07-11
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人