sqlite3 正在切割/切割/截断我的文本列 [英] sqlite3 is chopping/cutting/truncating my text columns

问题描述

我的值被截断了，想显示完整的值.

I have values being cut off and would like to display the full values.

Sqlite3 -column -header locations.dbs "
select n.namelist, f.state, t.state
from names n
left join locations l on l.id = n.id
left join statenames f on f.st = l.st
left join statenames t on t.st = l.stto
where n.timing > 200601 and count(n.timing)<=15"

给了我什么

name        From State   To State  
----------  -----------  ----------
Jack        Connecticut  Louisiana 
Jeff Danie  New Hampshi  New Hampsh

名称将被截断为 10 个字符或第一行数据的长度，以较长者为准.我怎样才能在不使列比它们必须更大的情况下阻止这种情况发生?

The names are being truncated down to 10 characters or the length of the first row of data, whichever is longer. How can I stop this from happening without making the columns larger than they have to be?

谢谢

推荐答案

似乎没有办法让它自动进行，但您可以使用 .width 命令手动指定列宽.

There doesn't appear to be a way to make it automatic, but you can use the .width command to manually specify the column widths.

请参阅此处(在该部分中搜索 .width).

See here (search the section for .width).

这篇关于sqlite3 正在切割/切割/截断我的文本列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！