Home  >  Article  >  Database  >  与MSSQL对比学习MYSQL的心得(三)--查看字段的长度_MySQL

与MSSQL对比学习MYSQL的心得(三)--查看字段的长度_MySQL

WBOY
WBOYOriginal
2016-06-01 13:09:58761browse

SQLSERVER


USE [sss]
GO
SELECT LEN([NAME]) FROM [dbo].[aa]

与MSSQL对比学习MYSQL的心得(三)--查看字段的长度_MySQL

MYSQL


CREATE TABLE tmp13(vb VARBINARY(10))
INSERT INTO tmp13 (vb) VALUES(12)
SELECT LENGTH(vb) FROM tmp13
INSERT INTO tmp13 (vb) VALUES(1212)


与MSSQL对比学习MYSQL的心得(三)--查看字段的长度_MySQL

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn