Is there any difference in storage between MySQL, VARCHAR(1000) and TEXT (purpose: to store long strings)?
PHP中文网
PHP中文网 2017-05-18 10:56:22

Actual Phenomenon

  1. Look forward to understanding the difference between VARCHAR/TEXT when storing large strings

  2. How to choose the type

  3. Understanding that TEXT will generate an intermediate virtual table

按照文档说明, VARCHAR(65536) --> 6KB --> 能存储足够大的字符串了

Expected Phenomenon

  1. Experience in data type selection (especially large strings)

PHP中文网
PHP中文网

认证高级PHP讲师

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!