Database Administrator

Use mysqlbinlog to extract binary logs The MySQL binlog log records all changes to the current database since the MySQL database is enabled. Binlog logs are binary files. We can extract binary logs to generate readable SQL statements to reconstruct

SQL Server Technical Summary The default Instance name for ms SQL Server is SQLExpress and the default TCP/IP Port Number is 1433. When a new instance is created instead of the default instance, the default port number is dynamic, therefore, you

Learning and thinking -- Analyzing function dependencies and multi-value dependencies in Databases Let's first review what is a function: A function corresponds to a set (I like to understand it in graphs) The figure shows single, full, and double

Oracle Integer type/DBNull processing method, oracledbnull 1. I used to think that integer = number (10,126) -- 38 is the maximum precision of number integer is a super large data type, the maximum value can be expressed as power) -1 because one

[Redis] redis overview, redis Overview Redis isOpen Source,Supported networks,Memory-based, persistentOfLog-type and key-value pairs, Which is written in ansi c. It also provides APIs in multiple languages.Fast feature Redis uses standard C to write

SQL statements for linux-IN and SQL-in In SQLINThis command. This page describes one of the commands --WHEREThe related situation. In this usage, we know at least one value we need in advance, and we put all these valuesINThis clause.INThe command

DB system alert contact API and db alert api Author: SkateTime: 2014/12/16   Database System Alert contact API   When we maintain the system, we need to transmit the system's alarm information to the corresponding students in real time. If we

Basic description and use of Protocol Buffers, protocolbuffers The reason we need to use protobuf is that when processing the contest module of OJ, we encounter a problem that a lot of information needs to be stored when generating contestRank. If

Details determine success or failure-Time Storage in mysql (datetime, timestamp, int),-mysqltimestamp To store time in mysql, we can use datetime, timestamp, or int format. So what should we consider when designing? First, I think we should

Precautions for uninstalling mysql Because the database software is very complex, there are many configurations to choose whether to install Mysql or sqlserver. If you fail to install the database for the first time, and then want to uninstall it

Impdp experience ORA-39001, ORA-39000, ORA-39142, impdpora-39001Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target data

MySQL paging implementationMysql> select pname from product; + -------- + | pname| + -------- + | Product 1| Product 2| Product 3 | + -------- + 3 rows in set (0.00 sec) this field indicates that all pnames are selected from the product. There are

Modify the default maximum number of connections in Oracle. The maximum number of connections in oracle is 100 by default, and the default value is 150 when creating a database, It is mainly subject to the processes system parameter (it should

Commonly used sql2 and sqlserversql2 in SQLServer -- Create table [dbo]. [BI_Dim_Date] (-- YYMMDD [DateF] [nvarchar] (20) NULL, -- French Date Format [DateKey] [nvarchar] (10) NULL, [Dim_Year] [int] NULL, [Dim_Month] [int] NULL, [Dim_Day] [int] NULL,

In linux, mysql changes the root password, mysqlroot Method 1: use the set password command First, log on to mysql mysql -u root -p Then run the set password command. set password for root@localhost = password('654321'); In the preceding example,

[MongoDB] MongoDB optimizer Profiler, mongodbprofiler In mysql databases, slow query logs are often used as the basis for database optimization. mongodb still has similar functions. The profiler provided by Mongodb allows you to easily record all

[Mysql] The SQL _mode configuration associated with Data truncated for column, truncatedsql_mode System Logs Ata truncated for column 'agent' at row 1 The reason for this problem in mysql is nothing more than Character Set setting or a too long

Troubleshooting of EXPDP stuck in AIX environment and expdp stuck in aix Environment Problem: A recent user is preparing to build a test environment. Because the official database of this user is an AIX midrange computer and the test environment is

Earlier versions use dblink to connect to 11G versions reports error ora-02063/ora-01017, dblinkora-02063 A home, a carrier called to create dblink error ora-02063/ora-01017 This BUG was not encountered once. ORACLE described the BUG as follows: Bug

SQL single-user lock table unlock, SQL unlock USE master;GO DECLARE @ SQL VARCHAR (MAX ); SET @ SQL ='' SELECT @ SQL = @ SQL + '; KILL' + RTRIM (SPID) FROM sysprocesses WHERE dbid = DB_ID ('wms. MDF '); EXEC (@ SQL ); GO Alter database [WMS.