, format: 2014-09-18 08:42:30
Timestamp
4 bytes, automatically stores the time the record was modified
Year
1 bytes, year
Integral type
MySQL data type
Meaning (Signed)
tinyint
1 bytes, range ( -128~127)
smallint
2 bytes, range ( -32768~32767)
Mediumint
3 bytes, range ( -8388608~8388607)
Int
4 bytes, range ( -2147483648~2147483647)
of whether the program has an exception
5. Use the display cursor whenever possible, and avoid using an implicit cursor
Transaction specification
1. All stored procedures or methods are counted at the end of commit or rollback
2. If you need to split a transaction, that is, the commit or ROLLBACK of the primary transaction does not affect the commit,rollback of the child transaction, use an autonomous transaction
Data Access Specification1. Background data is divided i
;+ ——— –+| Value |+ ——— –+| 131072.67 || 131072.69 |+ ——— –+1-6. We recommend using unsigned to store non-negative values.The same number of bytes stores a larger range of values. If the tinyint has a symbol of-128-127, unsigned 0-2551-7. How to use the int unsigned storage IP? Use the int unsigned instead of char (15) to store the IPv4 address and convert it through the MySQL function Inet_ntoa and Inet_aton. The Ipv6 address currently has no conversion function and requires a decimal or two bi
the same library, to facilitate rapid expansion of reading features read into real-time read and can be deferred to read the corresponding to the writing and reading library • Read/write separation should consider automatically switch to write-side schema decoupling when read is not availableProhibit cross-Library joinData life cycleArchiving of large-scale periodic sub-libraries based on the frequency of use of data Physical separation of the main library/archive libraryTable of log type shoul
(pub_idinch('1389','0736','0877','1622','1756')
ORpub_id like '99[0-9][0-9]'), pub_namevarchar( +)NULL,--nameCityvarchar( -)NULL,--CityStateChar(2)NULL,--StateCountryvarchar( -)NULL --National
DEFAULT('USA')
) B. SELECT statement Query statements are written using the following guidelines (to maximize the reuse of SQL statements in a shared pool to improve application performance):? Divide the SELECT statement into 5 parts: Select,from,where,group by, and ORDER by, each part of the bra
Specifications involve two sets of relationships, the first is abstraction and implementation, the second is the programmer and the user.From the first point of view: Abstract is a virtual thing, and implementation is a real thing, the implementation should be based on the abstraction to achieve, so the specification to describe the abstract to make it easier to implement.From the second point of view: The programmer is concerned about the user needs
Address: http://www.microtoolsinc.com/Howsrs.php
How to Write a software requirements specification
How to compile software requirement specifications
By Robert japenga
__________________________________________________________________________________________
What is the difference between a system specification and a software specification?
What is the difference between the system specification and the software specification?
Very often we find that
Directory
I. Functions of coding specifications
The second encoding specification is not "God of things"
3. Suggestions for coding specifications
Four encoding specifications reference
As software developers, we can develop low-level software, but not low-quality software. Therefore, how to implement quality assurance is one of our main concerns, while
What are the interface design standards for ASP. NET Programming specifications? First
Interface Design Standard for ASP. NET Programming specifications 1. Development Environment Settings:
The screen is set to 800*600/1024*768.
Interface Design Standards for ASP. NET Programming Specifications 2. Interface Design Principles:
Consistent Style
Interface Design Sta
Over the years, I have been engaged in PHP and C-related development in Linux and have brought many projects and teams. The following PHP coding specifications based on my experience can be used as examples and references for everyone, select and modify as needed!
(Some of the latest PhP5 specifications may be incomplete and will be updated in the future !)
Directory 1 writing Objective 2 Overall requiremen
In the process of daily project development and implementation, there will be a series of problems and tasks around the system, such as requirements, defects, suggestions, and tasks. In the context of systematic development of work information, generally, a unified problem tracking platform is used to record, track, and manage various problems, such as Jira and ITSM. The appendix summarizes and standardizes the problems I encountered during the early
Previous Article
Article Explained to the Team (for reference in this article)
The content of the ppt on the development specifications section during coding training,
Role of development specifications
1) Development specifications act on the internal development team to ensure that different developers are set in the work environment,
Code Development
Address: http://www.microtoolsinc.com/Howsrs.php
How to Write a software requirements specification
How to compile software requirement specifications
By Robert japenga
__________________________________________________________________________________________
What is the difference between a design requirement and software requirement?
What are the differences between design requirements and software requirements?
In short, the SRS shocould not inclu
1. Do not use document. write to output js files (corresponding to section 14.2 of Baidu frontend specifications)
Before reconstruction
In the school of management project, we do not need to modify the corresponding html or template when changing components to facilitate JS component calls ., divide the JS component modules and write a JS tool that outputs JS, as shown below:
Baidu frontend specifications
Universal Serial Bus (USB) since the advent of the 1996, unified PC external interface, and extended to a variety of consumer products, has long become a part of modern life. Published in 2000, the USB 2.0 high-speed specifications, providing 480Mbps transmission rate, has been more than 10 years of history, with the high-resolution audio-visual applications gradually popularized, frequently gbyte level of audio-visual materials, USB 2.0 bandwidth has
The importance of code specifications
A standardized code can usually get twice the result with half the effort. In my section below: code specifications are everywhere, but few companies do a good job of code standards. I can't help but want to talk about the importance of code specifications. I hope everyone can pay attention to them.
Moreover, I believe that i
, the ETL process needs to be repeated and maintained and improved continuously. 1.3 purpose of standardized formulation: ETL specifications are some rules and methods defined to ensure the correct design, implementation and maintenance of ETL, including ETL design specifications, development specifications, and maintenance s
EasyChen draws on the SINA Network Application Development Department C ++ development specifications, the Interaction Technology Department PHP4 development specifications, and the phpDocument development specifications. I think it is very good, suitable for PHP
EasyChen draws on the SINA Network Application Development Department C ++ development
What are the naming rules for ASP. NET Programming specifications? What is the specific content? Let's start:
ASP. NET Programming specification naming convention 1. Button ID naming:
Btn + button operation function such as btnSave)
Naming rules for ASP. NET Programming Specifications 2. Other controls:
I. It is related to data operations: Its ID
Field name + "_" + sequence number (starting with 01)
Exampl
Our most common advertising specifications are 468*60, and now we can see the advertising specifications are very diverse. The previous specification is Google AdSense, so it became an advertising alliance to emulate the model, now appears to be the most specifications of the Baidu Alliance.
Baidu Alliance advertising specif
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.