oracle插入O2O_SHOP_INFO_LS
程序员文章站
2022-07-08 12:38:04
...
insert into O2O_SHOP_INFO_LS (SHOP_NAME, SHOP_URL, AREA, PHONE, ADDRESS, EV_NUM, BAD_NUM, SCORE, PT_NAME, FP, OPEN_DATE, CITY, LAST_DATE,
SALES, CODE, MT_SEACH_URL, COMPANY_NAME, MT_PHONE, MT_ADDRESS, DZDP_SHOP_NAME, DZDP_SHOP_URL, DZDP_ADDRESS,
DZDP_PL, DZDP_OPEN_DATE, DZDP_PHONE, DZDP_WM, DZDP_ZZ, IS_CERT, ADDRESS_CODE, IS_YYZZ, IS_XKZ,
PUB_GRADE, XIAOQV, LON, LAT, UPDATE_ZT, IMG_ZZ_COUNT, PC, IS_LHFJ, CSDJ, GLDJ, JCRQ, DWMC, XKZH, FDDBR,
JYDZ, ZTYT, JYFW, YXQ, FL, INSERTDATE, DEATH, IMG_URL, SHOP_NAME2, PROVINCE1, CITY1, CITYCODE, DISTRICT,
ADCODE, LATITUDE, LONGITUDE, CHECK_DATE, CHECK_RESULT, AUTHENTIC_ID, ISPPXKZ, IS_XKZGQ, IS_CFWJY, IS_YZDY, ZT)
select
SHOP_NAME, SHOP_URL, AREA, PHONE, ADDRESS, EV_NUM, BAD_NUM, SCORE, PT_NAME, FP, OPEN_DATE, CITY, LAST_DATE,
SALES, CODE, MT_SEACH_URL, COMPANY_NAME, MT_PHONE, MT_ADDRESS, DZDP_SHOP_NAME, DZDP_SHOP_URL, DZDP_ADDRESS,
DZDP_PL, DZDP_OPEN_DATE, DZDP_PHONE, DZDP_WM, DZDP_ZZ, IS_CERT, ADDRESS_CODE, IS_YYZZ, IS_XKZ,
PUB_GRADE, XIAOQV, LON, LAT, UPDATE_ZT, IMG_ZZ_COUNT, PC, IS_LHFJ, CSDJ, GLDJ, JCRQ, DWMC, XKZH, FDDBR,
JYDZ, ZTYT, JYFW, YXQ, FL, INSERTDATE, DEATH, IMG_URL, SHOP_NAME2, PROVINCE1, CITY1, CITYCODE, DISTRICT,
ADCODE, LATITUDE, LONGITUDE, CHECK_DATE, CHECK_RESULT, AUTHENTIC_ID, ISPPXKZ, IS_XKZGQ, IS_CFWJY, IS_YZDY, ZT
from o2o_shop_info_app where city1='三亚市' and zt='1'
上一篇: java启动相应的windows程序来打开文件,"rundll32 url.dll,FileProtocolHandler " + sbUrl.toString
下一篇: Java生成全局唯一标识符
推荐阅读
-
MySQL下将一个表的数据插入到另外一个表的实现语句
-
windwos下使用php连接oracle数据库的过程分享
-
plsql develope连接64位Oracle 11g出错解决方案(图)
-
Oracle数据表转换为Shapefile文件图文说明
-
BarTender条码打印怎么插入动态图片?
-
Oracle数据库备份---导出与导入
-
使用Navicat for Oracle工具连接oracle的图文教程
-
sql server 2005如何导出数据到oracle 11g
-
PowerDesigner 建立与数据库的连接以便生成数据库和从数据库生成到PD中(Oracle 10G版)
-
Navicat Premium 10.0.5中文版 oracle连接字符集报错解决办法