local time zone

On the basis of the Linux system after installation--based on CentOS (5.8/6.4)--we mentioned how to automatically update the server time at timed intervals. Also mentioned, when the number of intranet machines, if all go to the public network NTP

Date Processing Time Date type The date datetime type, which contains the time portion of the year, month, day, hour, minute, second, not containing the number of decimal digits and time zone of the second. Valid data range is January 1, 47

Mysqlbinlog Usage NotesThe binary log file generated by the server is written in binary format. To check these text-formatted files, you should use the Mysqlbinlog utility.This should be called Mysqlbinlog:Shell> mysqlbinlog [options] log-files ...

Revocation ManagementWhat is undo data:1. Transaction fallback: No transaction submitted can be rollback2. Transaction recovery: When the database crashes, the incorrect data of the disk is restored to the pre-transaction3. Read consistency: The

Deadlock:Session1:Sql> select * from T1;X----------12sql> Update T1 set x=11 where x=1;Session2:sql> Update T1 set x=22 where x=2;Session1:sql> Update T1 set x=222 where x=2; BlockingSession2:sql> Update T1 set x=111 where x=1; Dead lockERROR at

With the improvement of a large number of default options, MySQL 5.6 has significantly fewer options than the previous version needs tuning. In this article I will describe the configuration items that need to be optimized.InnoDB

Oracle Basic data types: string, number, date, LOB, LONG raw& RAW, ROWID & Urowid.The data of string types can be divided into:According to the library character set (Char/varchar2/clob/long)International character Set (NCHAR/NVARCHAR2/NCLOB)String

A String typeThe string data type can also be divided into fixed-length types (char/nchar) and variable-length types (VARCHAR2/NVARCHAR2) based on storage space.Fixed length: means that although the input field value is less than the limit length of

Cause:The inconsistency of data events in the credit database resulted in the confusion of data (RAC cluster), inconsistent Plsql query time and database time, which seriously affected the business. Because I just met once, and with the MySQL time

I. Data types in OracleOracle provides a rich data type for storing data, mainly including:　　1, character type: Mainly used to store string type of data.　　 Data type Length Description CHAR (n Byte/char)

SQLite includes the following time/date functions:DateTime () ......... ........ Date and time of generationDate () ........ ............ Date generatedTime () ........ ............ Generation timeStrftime () ........ ......... Format the date and

After years of controversy, Microsoft finally cut the date-time data type, adding 4 new date-time data types in one breath in the new version of SQL Server 2008, including: Date: A pure date data type. Time: A pure temporal data type.

Binlog is a binary log file of MySQL record operation, there are three formats to choose from, but the old SBR is not suitable for most business needs now, so most of them are recommended to use MBR and RBR, that is, mixed or row, and the reason for

1:java data type and MySQL data type comparison table Type name Display length Database type Java type JDBC Type index (int) VARCHAR L+n VARCHAR Java.lang.String 12

Oracle Basic data types:Oracle's basic data types are categorized by type: String type, data type, date type, LOB type, and so on.1. String Type:①char: fixed-length string that stores up to 2k bytes, and defaults to a length of 1 bytes without

Oracle Basic data types (also called built-in data types built-in datatypes) can be categorized by type: String type, Number type, date type, LOB type, LONG raw& RAW type, ROWID & urowid type.Before Apple told the string type, let's talk about

Mysqlbinlog commandRole: Mysqlbinlog is used to parse the Binlog log of MySQL.[[Email protected] data]# file mysql-bin.000001Mysql-bin.000001:mysql Replication Log[Email protected] data]#Mysqlbinlog logs cannot be viewed directly with cat and need

 how to query the MySQL logCategory: MySQL2012-02-23 19:14 26756 People read Comments (2) favorite reports MysqlcommandprintingserversocketoutputToday, the American boss sent an email, a word of what happen to ...? Any other clues do not, I give

Using date types in PL/SQLThe previous article described the use of strings and numbers in PL/SQL. There is no doubt that strings and numbers are important, but you can be sure that no application is dependent on the date.You need to record events,

One, running the MySQL server as a non-privileged userBefore discussing how to start the MySQL server, let's consider the user who should run the MySQL serviceManager The server can be started manually or automatically. If you manually start it, the