Shulou(Shulou.com)06/02 Report--

This article mainly introduces "how to use mysql char and varchar". In daily operation, I believe many people have doubts about how to use mysql char and varchar. I have consulted all kinds of materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "how to use mysql char and varchar"! Next, please follow the small series to learn together!

description

1, know the fixed length of char, often changing fields with varchar.

2, try to use varchar, more than 255 characters can only use varchar or text, can use varchar place do not use text.

examples

CREATE TABLE char_test( char_col CHAR(10)); INSERT INTO char_testVALUES ('string1'). (' string2'). ('string 3'); At this point, the study of "how to use mysql char and varchar" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.