)
Small integer value
SMALLINT
2 bytes
(-32 768,32 767)
(0,65 535)
Large integer value
Mediumint
3 bytes
(-8 388 608,8 388 607)
(0,16 777 215)
Large integer value
called the anonymous function of self invocation or the function expression (Iife) that is called immediately. When you create it, it automatically executes the function.
(function () {Some private code that'll be executed automatically})();(function (a,b) {var result = A+b;return result;}) (10,20)
8, random access to an array of items
var items = [548, ' a ', 2, 5478, ' foo ', 8852, ' Doe ', 2145, 119];var Randomitem = Items[math.floor (Math.random () * items.length)];
9. Get a random numb
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, the 3 different lengths of Tinyint,mediumint,bigint were added, and bit types were added to store the bit data.
Integer type byte range (signed) range (unsigned) purpose
TINYINT 1 byte (-128,127) (0,255) Small integer value
SMALLINT 2 bytes (-32
Tags: mysql signed occupy logical definition Bin binary class datetimeMySQL field typeMySQL supports multiple types and can be broadly divided into three categories: numeric, date/time, and string (character) types.Numeric type
type
size
Range (signed)
Range (unsigned)
Use
TINYINT
1 bytes
(-128,127)
(0,255)
Small integer value
SMALLINT
2 bytes
(-32 768,32 767)
(0,65 535)
Large integer value
Tags: ref requires blog mes fill duration bin function failedMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled.The table lists the various numeric types, their allowable ranges, and the amount
Tags: Lin space large text large integer amp and size-128 stringMySQL supports multiple types and can be broadly divided into three categories: numeric, date/time, and string (character) types. 1). Data Type
Type
Size
Range (signed)
Range (unsigned)
Use
TINYINT
1 bytes
(-128,127)
(0,255)
Small integer value
SMALLINT
2 bytes
(-32 768,32 767)
(0,65 535)
Large integer value
Med
Digital type
Type
Size
Range (signed)
Range (unsigned)
Use
TINYINT
1 bytes
(-128,127)
(0,255)
Small integer value
SMALLINT
2 bytes
(-32 768,32 767)
(0,65 535)
Large integer value
Mediumint
3 bytes
(-8 388 608,8 388 607)
(0,16 777 215)
Large integer value
int or integer
4 bytes
(-2 147 483 648,2
MySQL supports a variety of data types, and the big nephew can be divided into three categories: numeric type, Time type, string type, and conforming type;Numeric type:
Type
Size
Range (signed)
Range (unsigned)
Use
TINYINT
1 bytes
(-128,127)
(0,255)
Small integer value
SMALLINT
2 bytes
(-32 768,32 767)
(0,65 535)
Large integer value
Mediumint
3 bytes
(-8 388 608,8 388 607
an ASCII code. The method has one parameter: Parameter 1: Specify a numeric value of type int with a range of values from 0 to 255. Returns null to indicate that an integer expression is not within this range. Select Char --return c
Select char (9)- -Tab character
select char (TEN)- -newline character
select char (in.)- - Carriage return character ASCII (): Returns the ASCII code value of the first character of a specified character or string. The method has one parameter: Para
MySQL data typeFirst, numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled. The table lists the various numeric types, their allowable ranges, and the amount of memory space they occu
MySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled.The table lists the various numeric types, their allowable ranges, and the amount of memory space they occupy.Type size range (signed) range (
MySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled.The table lists the various numeric types, their allowable ranges, and the amount of memory space they occupy.type size range (signed) range (
Provenance http://blog.sina.com.cn/s/blog_46f224ea010008zp.html Numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled.The table lists the various numeric types, their allowable ranges,
) NOT null default ' ',Sex enum (' Male ', ' female '),Hobby set (' Sing ', ' swim ', ' die '));When creating a database to set the font encoding to prevent garbled and name the database name can not be used with pure digital symbols and system keywords and because the Linux system is case-sensitive so that the database name preferably lowercase and not more than 64 bitsDesc newtable;Is the structure of the query table, to see how each of his head is set up just like the ID in the NewTable table
Numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled.The table lists the various numeric types, their allowable ranges, and the amount of memory space they occupy.
Type
MySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of different sizes, and MySQL allows us to specify whether the value in a numeric field is positive or negative or 0 filled.The table lists the various numeric types, their allowable ranges, and the amount of memory space they occupy.Type size range (signed) range (
Tags: mysql data typeI. Numeric typeMySQL supports all numeric types in standard SQL, including strict data types (integer,smallint,decimal,numberic), and approximate numeric data types (float,real,double presision). and expand on this basis.The extension adds tinyint,mediumint,bigint to these 3 different lengths of shaping and adds a bit type for storing bit data.Integer type byte range (signed) range (unsigned) useTINYINT 1 bytes (-128,127) (0,255) Small integer valueSMALLINT 2 bytes (-32 768,
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.