常用的sybase iq数据库导表语句

最新推荐文章于 2021-06-29 17:59:51 发布

weixin_34148340

最新推荐文章于 2021-06-29 17:59:51 发布

阅读量369

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/1866459/blog/471274

版权

2019独角兽企业重金招聘Python工程师标准>>>

create table exttable_phone_imsi(imsi char(25));
load table exttable_phone_imsi
(
imsi 0x0a
)
using file '/home/sybase/imsi.txt'
quotes off
escapes off
go

drop table exttable_phone_id
go

create table exttable_phone_id(
phonenum varchar(100),
imsi varchar(100),
imei varchar(500),
phonemodel varchar(500),
mac varchar(100))
go

desc formatted exttable_phone_id

load table exttable_phone_id
(
phonenum          '|',
imsi              '|',
imei              '|',
phonemodel        '|',
mac               0x0a
)
using file '/home/sybase/yym.txt'
quotes off
escapes off
go

create table tmp_yym_gw20150527(
gw_account varchar(100),
search_key varchar(100))
go

load table tmp_yym_gw20150527(
gw_account '|',
search_key 0x0a)
using file '/home/sybase/gw.txt'
quotes off
escapes off
go

create table tmp_gwtimes(
gw_account varchar(100),
times int)
go

load table tmp_gwtimes(gw_account '|',
times 0x0a)
using file '/home/sybase/gwtime.txt'
quotes off
escapes off
go