mysql
史小屁
这个作者很懒,什么都没留下…
展开
-
提取地址
select if(LOCATE('弄',房屋地址)>0,left(房屋地址,LOCATE('弄',房屋地址)), left(房屋地址,LOCATE('村',房屋地址))) as 提取 from 16nian; select 房屋地址,(case when LOCATE('支弄',房屋地址)>0 then left(房屋地址,LOCATE('支弄',房屋地址)+1) whe原创 2018-01-15 11:00:00 · 354 阅读 · 0 评论 -
16年二手交易金额时间序列
library(RMySQL) connect host = 'localhost', user = 'root', password = '123456', dbname = 'ninashuju') # 只需给原创 2018-01-16 16:41:59 · 194 阅读 · 0 评论 -
mysql导入中文
ALTER TABLE nian_16 CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/wokek.csv' into table nian_16character set gbkfields terminated ...原创 2018-02-09 10:05:52 · 266 阅读 · 0 评论 -
数据库导入汉语文件
#导入数据create table 表1 like 表2;ALTER TABLE 16_nian CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/WORKs.csv' into table 16_nianchara...原创 2018-02-28 09:24:35 · 157 阅读 · 0 评论