Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL数据库的varchar长度详细介绍

MySQL数据库的varchar长度详细介绍

WBOY
Release： 2016-06-07 17:51:01
Original
1187 people have browsed it

在MySQL5.0.3及以上的版本中，varchar数据类型的长度支持到了65535，也就是说可以存放65532个字节的数据，起始位和结束位占去了3个字节，也就是说，在5.0.3以下版本中需要使用固定的TEXT或BLOB格式存放的数据可以在高版本中使用可变长的varchar来存放，这样就

Related labels：
mysql varchar
source：php.cn
Previous article：几种删除重复记录的sql语句 Next article：mysql中文乱码问题解决方法
Statement of this Website
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
Latest Articles by Author
Latest Issues
I need to have employees with same joining month and year CREATETABLE`staff`(`StaffID`intNOTNULLAUTO_INCREMENT,`Surname`varchar(40)DEFAULTNULL,`Give...
From 2024-04-04 20:28:20
0
2
352
Get the latest row of data table: task: id (bigint) name (varchar). Save task details job: id(varchar(UUID))task_id(b...
From 2024-04-02 15:27:20
0
1
341
The length of varchar storage in mysql Sorry, English is not my native language... :( I wanted to understand how the actual lengt...
From 2024-04-01 15:50:34
0
1
293
Calling a stored procedure is much slower than calling an insert, and bulk inserts are basically the same, why? I have a table and a stored procedure as shown below, CREATETABLE`inspect_call`(`id`bigint...
From 2024-03-30 12:42:40
0
1
321
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template