This section briefly describes five data types in SQL: numeric, text, numeric, logical, and date.
Character Type
Varchar and char
The differences between varchar and char data are subtle, but important. They are used to store strings of less than 255
3.3 Numeric data typesFrom the moment we open our eyes every morning, we deal with numbers almost every hour: from 6:30 on the alarm clock to the 216 bus to work, from the news that the house price fell to 100 yuan per square meter to go home to buy
3.3 Numeric data typesFrom the moment we open our eyes every morning, we deal with numbers almost every hour: from 6:30 on the alarm clock to the 216 bus to work, from the news that the house price fell to 100 yuan per square meter to go home to buy
Data | The data type SQL92 standard defines several basic data types, which are the basis for various data types in the SQL database. In the article "string data type", we have discussed in detail the string data types defined by the SQL92 standard.
Character and string processing functions: Character and string processing functions are all character data, but their return value types are different.1. Take the SUBSTRING function:Format: substr (C,N1,N2)Function: Take the string C N1 character
Comparison of NUMERIC and DECIMAL types in Mysql, numericdecimal
Decimal (numeric) is synonymous and used to precisely store values.
A decimal data type can store up to 38 numbers. All numbers can be placed on the right of the decimal point. The
Decimal (numeric) synonymous with the exact storage of numeric values.
The decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type stores an accurate (accurate) numeric
Type conversion between basic types (numeric type), type conversion numeric type
As soon as I opened my blog today, I saw the 5-year-old campus in the upper left corner, and my eyes were a bit blank. The scenes of my previous class as a student have
The SQL92 standard defines several basic data types, which are the basis for various data types in the SQL database. In the article "string data type", we have discussed in detail the string data types defined by the SQL92 standard. Now let's
Decimal (numeric) synonymous for precise storage of numeric valuesfloat and real cannot store values accuratelyThe decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.