mysql查询字段占用的字节数_如何查看一个条记录的一个字段实际占用多少字节？...

最新推荐文章于 2022-06-24 10:17:00 发布

weixin_39644713

最新推荐文章于 2022-06-24 10:17:00 发布

阅读量2.5k

点赞数

文章标签： mysql查询字段占用的字节数

本文链接：https://blog.csdn.net/weixin_39644713/article/details/113459696

版权

这段内容展示了SQL查询的结果，包括数据库表的多个字段信息，如OWNER、OBJECT_NAME、OBJECT_TYPE等，并进行了对象ID和对象名称的数据长度与占用字节的比较，揭示了数据一致性的问题。

摘要由CSDN通过智能技术生成

比较一下对于各种不同类型的结果

SQL> desc test.test;

Name Null? Type

----------------------------------------------------------------------------- -------- ----------------------------------------------------

OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(128)

SUBOBJECT_NAME VARCHAR2(30)

OBJECT_ID NUMBER

DATA_OBJECT_ID NUMBER

OBJECT_TYPE VARCHAR2(18)

CREATED DATE

LAST_DDL_TIME DATE

TIMESTAMP VARCHAR2(19)

STATUS VARCHAR2(7)

TEMPORARY VARCHAR2(1)

GENERATED VARCHAR2(1)

SECONDARY VARCHAR2(1)

SQL> select vsize(object_id),length(object_id),object_id from test.test where rownum<5 and vsize(object_id)<>length(object_id)

2 ;

VSIZE(OBJECT_ID) LENGTH(OBJECT_ID) OBJECT_ID

---------------- ----------------- ----------

3 4 2106

3 4 2110

3 4 4253

2 1 5

SQL> select vsize(object_name),length(object_name),object_name from test.test where rownum<5 and vsize(object_name)<>length(object_name);

no rows selected

Elapsed: 00:00:00.00

SQL> select vsize(CREATED),length(CREATED),CREATED from test.test where rownum<5 and vsize(CREATED)<>length(CREATED);

VSIZE(CREATED) LENGTH(CREATED) CREATED

-------------- --------------- ---------

7 9 18-NOV-05

Elapsed: 00:00:00.00

关注