我正在尝试从myTable
到H2运行以下查询
select * from MYTABLE;
表模式
sql> show columns from mytable;
FIELD | TYPE | NULL | KEY | DEFAULT
UNIQUE_JOB_NAME | VARCHAR_IGNORECASE(256) | NO | | NULL
UNIQUE_STEP_NAME | VARCHAR_IGNORECASE(256) | YES | | NULL
OBJECT_CLASS_NAME | VARCHAR_IGNORECASE(256) | NO | | NULL
OBJECT_NAME | VARCHAR_IGNORECASE(256) | NO | | NULL
OBJECT_DATA | VARBINARY(2147483647) | NO | | NULL
结果返回
sql> select * from mytable;
UNIQUE_JOB_NAME | UNIQUE_STEP_NAME | OBJECT_CLASS_NAME | OBJECT_NAME | OBJECT_DATA
someValue | null | someValueJobData | someValueJobData | aced00057372004d636f6d2e656d632e636c6f75645f64722e6364722e636f6d6d6f6e732e636f6d6d6f6e5f6d6f64656c73
(data is partially truncated)
(1 rows, 2 ms)
命令连接到H2
java -cp h2-1.4.199.jar org.h2.tools.Shell -url "jdbc:h2:path/to/h2/mydb" -user randomuser -password randompass
他们是否要求h2-cli不截断结果数据?
发布于 2022-08-22 11:02:06
在h2控制台集中: sql>最大宽度10000
https://stackoverflow.com/questions/68828495
复制相似问题