text数据类型,插入SQL无法执行,报错
DDL:
CREATE TABLE datax:xm_market_api_mask (
id BIGINT NOT NULL,
status INTEGER,
create_user_id BIGINT,
update_user_id BIGINT,
remark LVARCHAR(1000),
api_id BIGINT,
mask_name VARCHAR(50),
config_json TEXT,
deleted INTEGER DEFAULT 0,
create_time DATETIME YEAR TO FRACTION(5),
update_time DATETIME YEAR TO FRACTION(5),
mask_type INTEGER DEFAULT 1,
system_id BIGINT NOT NULL,
PRIMARY KEY (id) CONSTRAINT u104_5 disabled
)
in datadbs4 ;
插入SQL:
INSERT INTO datax:xm_market_api_mask
(id, status, create_user_id, update_user_id, remark, api_id, mask_name, config_json, deleted, create_time, update_time, mask_type, system_id)
VALUES(1, 0, 1, 1, '', 1699260043708665857, 'cipherTypeSelectChanged', '[{"fieldName":"k_name","cipherType":"2","cryptType":"3"}]', 1, '2023-09-06 11:27:39', '2023-09-06 11:27:39', 2, 10000001);
异常:

评论

[gbasedbt@peixun-0054 gbase]$ cat t1.unl
dsajkdkjascbkjascjk
[gbasedbt@peixun-0054 gbase]$ dbaccess mydb -
Database selected.
> create table t2 (abc text);
Table created.
> load from '/opt/gbase/t1.unl' insert into t2;
1 row(s) loaded.
> select * from t2;
abc
dsajkdkjascbkjascjk
1 row(s) retrieved.
>
或者使用load的方式。
热门帖子
- 12025-12-01浏览数:182763
- 22023-05-09浏览数:25059
- 42023-09-25浏览数:18525
- 52020-05-11浏览数:17529
text类型需要load 。
如果内容不是很长,可以使用varchar类型,可以直接插入