1. database table name naming specification The use of 26 letters (case-sensitive) and 0-9 of the natural number (often do not need) with an underscore ' _ ' composition; The name is concise and clear, and multiple words are separated
Bit[(m)] bits (101001), M represents the length of bits (1-64), default M=1 tinyint[(m)] [unsigned] [zerofill] small integer, data type is used to hold a Range of integers: Signed:-128 ~ 127. Unsigned: 0 ~ 255 Special: MySQL has no
MySQL data typeIn MySQL , there are three main types: text, numbers, and date/time types.Text Type:
Data Type
Description
Notes
CHAR (size)
Holds a fixed-length string (which can contain letters,
varchar and text is the MySQL character storage dispute more than the field, the big print paragraph with that better, let us compare, and then choose by ourselves.Size comparisonVarchar:varchar satisfies the maximum row limit in MySQL, which is 6553
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
The type of data field defined in MySQL is very important for your database optimization;MySQL supports multiple types and can be broadly divided into three categories: numeric, date/time, and string (character) types;Integer typeMeaning of N in Int
NT (M) let's first split, int is representing integer data so the middle of the M should represent how many bits, and later the MySQL handbook also learned that my understanding is correct, I would like to illustrate.The integer types in the MySQL
Review Database basics, relational databases (rows/Records, columns/fields, SQL)Basic SQL Operations: library operations, table operations (fields), and data operationsCharacterProofing Sets 1. What is a proofing set?The collation set refers to the
MySQL uses many different data types, generally divided into three categories: number, date, time, and string type, and the corresponding data types are described below1, numeric data typeINT-A normal-sized integer that can be signed. If it is
ObjectiveAs in C + +, how many bytes are required to define an int type, and how many bytes are required to define the double type, MySQL has strict control over the data in each column of the table, which is key to the success of the data-driven
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
SOURCE website http://www.runoob.com/sql/sql-datatypes.htmlThere are three main types of MySQL data type: text text, number numeric, and date DateTime.1 Text type
Data Type
Description
CHAR (size)
Holds a
servlet DevelopmentThe user enters a URL in the browser and returns, and the browser sends an HTTP request to the server. The server-side program accepts the request, processes the request, and then sends a response. The browser receives a response
Javaweb Knowledge Point Summary OneCommon status codes and their meaningsSome common HTTP status codes are: --Server successfully returned to Web page The server does not understand the syntax of the request404 --The requested page does not exist503
Today, the most popular software station editor encountered a problem when writing a small PHP item. When designing the database type, it prompts: xxxx used in key specification without a key length, which cannot be solved by any means, later, I
Oracle dbms_output two minor issues of dbms_output in oracle 1. If the content of dbms_output.put_line cannot be displayed, You need to first input set serveroutput on in the command line; just repeat it, after dbms_output.put_line content can be
1. Create dataIf no table is added to the database, the database is not created and no files are generated on the hard disk. If the database already exists, the database is opened.2. How to generate the sqlite3.lib file through sqlite3.dll and
First, several basic concepts
Cookie spoofing means that, in a system that only performs Cookies verification on users, users can log on to the system by modifying the Cookies.
So what is Cookies? Here I will give you a professional explanation.
6.1 data access page view test site 1 page view is a way to view the generated data access page style. When you open a data access page in the design view of Test Site 2, you must modify the data access page. Click the name of the data access page
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.