Shulou(Shulou.com)05/31 Report--

Most people do not understand the knowledge points of this article "how to apply mysql char and varchar", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to apply mysql char and varchar" article.

Description

1. Know that fixed-length fields use char, and frequently changing fields use varchar.

2. Try to use varchar. If you have more than 255characters, you can only use varchar or text. Where you can use varchar, you don't need text.

Example

CREATE TABLE char_test (char_col CHAR (10)); INSERT INTO char_testVALUES ('string1'). ('string2'). ('string3'); the above is the content of this article on "how to use mysql char and varchar". I believe you all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

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.