Mysql Data Type 1. mysql Data TypeMysql has the following data types:(1) The numeric value www.2cto.com is a value such as 32 or 153.4. Mysql supports scientific notation, which is expressed by an integer or floating point followed by "e" or "e", a
Encountered some problems also found in the above Web site answers
Below is the contents of my index profile mysql.conf
[PHP]SOURCE MySQL{Type = MySQL Sql_host = localhostSql_user = rootSql_pass = Mfysql_db = ZlkSql_port = 3306Sql_query_pre = SET
MySQL self-study (III) and mysql self-study
MySQL Data Type
MySQL supports multiple data types, including numeric, date, and string.Value Type
MySQL mainly provides INTEGER types: TINYINT/SMALLINT/MEDIUMINT/INT (INTEGER)/BIGINT
You can add the
Mysql learning notes: basic operations on tables and mysql learning notes
Create a table
Create table Name
Create table if not exists table name
mysql> create database company;Query OK, 1 row affected (0.00 sec)mysql> use company;Database
Sphinxcoreseek. Some questions have been found on the above website. The following is my index configuration file mysql. conf content [php] sourcemysql {typemysqlsql_hostlocalhostsql_user has encountered some problems and found answers on the above
A. Numeric type
MySQL supports numeric types in all standard SQL, including strict data types (integer,smallint,decimal,numberic), and approximate numeric data types (float,real,double presision). And on this basis to expand.
After the expansion,
This article lists the MySQL data type list, which consists of five main categories: integer type, floating-point type, String type, date type, and other data types, which are explained in detail in the following five data types. There are also the
1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (m)
2 byte range ( -32768~32767)
Mediumint (M)
3 byte range ( -8388608~83
17/7/91. The master-slave architecture (Client-server model) or the client-server (CLIENT-SERVER) structure is called C/s structure, is a network architecture, usually in this network architecture software is divided into clients and servers. 2. The
Reprint Https://www.baidu.com/s?ie=UTF-8&wd=cnblogThe original tears Yunshan Hai blog MySQL data type1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (
MySQL has a large number of data types that can be divided into: date and time, numeric value, and string. Let's summarize them separately.Database type selection has a significant impact on the performance of the database1. Data types can affect
Date and time data types
MySQL data type
Meaning
Date
3 bytes, date, format: 2014-09-18
Time
3 bytes, time, format: 08:42:30
Datetime
8 bytes, date time, format: 2014-09
Constraints:Not null : Non-null constraint, specifying that a column is not emptyUnique : Unique constraint, specifying that data for a column and a combination of columns cannot be duplicatedPRIMARY Key : PRIMARY KEY constraint, specifying that
This article transferred from: http://www.cnblogs.com/zbseoag/archive/2013/03/19/2970004.html1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (m)
1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (m)
2 byte range ( -32768~32767)
Mediumint (M)
3 byte range ( -8388608~83
1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (m)
2 byte range ( -32768~32767)
Mediumint (M)
3 byte range ( -8388608~83
1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (m)
2 byte range ( -32768~32767)
Mediumint (M)
3 byte range ( -8388608~8388607
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.