Database Administrator

RHEL5.7 64-bit source code compilation and installation of MySQL-5.5.42 Problems Since MySQL is compiled and installed from source code Versions later than MySQL 5.5 using cmake, make, and make install, no. /Configure, make, make install, so check

MariaDB10.0 instance deployment and multi-source replication Configuration 1. Deploy MariaDB10.0.17 1. Download and briefly describe MariaDBCurrently, MariaDB supports multi-source replication of version 10.0. The latest stable version is 10.0.17.

Backup _ imp import error due to inconsistent client and database versions Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Mybatis, mybatis 1. Introduction to MyBatis MyBatis is an excellent persistent layer framework that supports common SQL queries, stored procedures, and advanced mappings. MyBatis eliminates the manual setup of almost all JDBC code and parameters and

Sqlyog writes the mysql stored procedure, sqlyogmysql Damn it, it's really strange to write a stored procedure fuck, such a simple thing. That is, the number of fucking spaces is less than the number of spaces. It's really troublesome. I spent half

Mysql paging stored procedure and mysql Stored Procedure There is a lot of information about the mysql paging stored procedure on the Internet, but the content is similar. As a beginner, reference the mysql stored procedure as follows: DELIMITER $

Redis 3.0.0 official version released, high-performance K/V service, redis3.0.0 The official version of Redis 3.0.0 has finally arrived. Compared with the RC6 version, the improvements include: * Oran Agra)* Test BLPOP replication after the role

Oracle Database 11g Release 2 installation On CentOS 6.6 (x64 platform), centosx64Oracle Database 11g Release 2 installation On CentOS 6.6 (x64 platform)(Note: the current user is "tdtc100 ")1. down install files(1) linux.x64_11gR2_database_1of2.zip(

Cross-connection and full-connectionIn addition to displaying rows that meet the conditions of the join, the results also show all rows that meet the search conditions in the tables on both sides of the join operation.SQL> select e. empno, e. ename,

Stored Procedures, database Stored Procedures Use yuyongTest; Go   -- Define a stored procedure and input an int parameter to this stored procedure. This stored procedure will assign a value (as a result) to a parameter of the nvarchar (50) type)

[Err] ORA-00923: FROM keyword not found where expected and rownum, ora-00923rownumAbout oracle's nownum If I want to query all the table information and add the row number in front of it, the SQL statement is as follows:Select ROWNUM, * from

Are you still worried about database garbled Characters ?, Database garbled troubles 1. First, you need to modify the mysql database configuration file my. ini, This file is stored in the mysql root directory. Search for the default-character-set

Timesten upgrade, timesten TtIsql "DSN = ttwind; UID = cacheuser; PWD = cacheuser; OraclePWD = cacheuser ;" -- 1. view the current version Command> versionTimesTen Release 11.2.2.7.0 Command> cachegroups; Cache Group CACHEUSER. CACHETBLORDERS: Cache

Mysql Master never synchronizes processing-database initialization, mysql -- Learn from online content for troubleshooting Re-master, full synchronization After creating a new table in the master database, the data in the slave segment is not

Mysql reorganizes notes -- woods memo, mysql -- woods================================ SQL memo CRUD queries multi-table events and so on ==== ==================================Example 1. database 1. create database [if not exists] db_name [character

Mongodb3.0 Performance Test Report 1: mongodb3.0 performance test Test environment: Servers: 6 X86 pcservers Cpu: single 8-core Memory: 64 GB Disk: raid 10 Operating System: centos 6.5 Mongodb: 3.0 Java DRIVER: 2.8.0 Jdk: 1.6 Network: Gigabit

HBase basic API (java) Operations (add, delete, modify, and query), hbaseapi // Package hbaseExec2;/** create a students table and perform related operations */import java. io. IOException; import java. util. arrayList; import java. util. list;

Oracle select into prevents failure to report an error, oracleselect As follows: Begin select name into v_name FROM t_student WHERE id = '000000' exception when NO_DATA_FOUND THEN v_name: = ''; END; In this way, you do not need to select count (1)

PostgreSQL dropdb connection not closed, postgresqldropdb For example: Solution: 1. select * from pg_stat_activity where datname = 'lnarterydb' // query sessions in the database The query result has two PIDs. 2. SELECT pg_terminate_backend

Oracle table access permission control and oracle access permission Control Currently, a database user SYSUSER has permissions on all tables. Another system wants to access a table in my database. I don't want him to control all tables in my