数据库的数据类型（Data type of database）.docVIP

数据库的数据类型（Data type of database） MySQL data types and column types 1. MySQL data type There are several data types in mysql: (1) numerical Values are values such as 32 or 153.4. MySQL supports scientific notation. Scientific notation consists of integers or floats followed by e Or e, a symbol (+ or -) and an integer index. Both 1.24e+12 and 23.47e-1 are legitimate scientific tables The number expressed by a notation. And 1.24e12 is not legal because the index before the symbol is not given A floating point is made up of an integer part, a decimal point, and a decimal part. The integer part and the fractional part can be empty, but not at the same time For empty. The numerical can put a minus sign - to represent a negative value. (2) character (string) type Character type (also called string type, referred to as string) such as Hello, world! or caused by a Steamed Buns of murder this value, Or a value such as phone number You can enclose either a single quotation mark or a double quotation mark to enclose the string value. Beginners often cant tell the difference between valueand string Its all numbers. How do you use numeric values?, How about a character type? The key is: the numericalis to participate in the calculation, for example, it is a total amount of money in the finance; And character typeis not involved in the calculation, just that the phone number, and so there are street numbers, house numbers, and so on, they are all Not involved in calculation. (3) date and time type; Date and time are values such as 2006-07-12 or 12:30:43. MySQL also supports a combination of date / time, Such as 2006-07-12 12:30:43. (4) null value Null represents an unknown value. For example, fill in the address space is not clear not fill in, this is the value of null. We create a table with the CREATE TABLE statement (see the previous section), which contains the definition of columns. For example, we are there A table joke is cre