Database Administrator

Several causes of MySQL garbled characters MySQL is garbled for the following reasons: 1. garbled characters before they are stored in the database 2. garbled Characters During database saving 3. garbled characters after being stored in the

Modifying Instance name SID in Oracle Modify the Oracle Instance name System Environment: CentOS 6.5ORACLE version: 10.2 1. Check the original database instance name$ Echo $ ORACLE_SIDOrcl $ Sqlplus/as sysdba> Select instance from v $

Several errors and solutions encountered during manual creation of Oracle, oracle Solutions There are a lot of errors when you create an Oracle database manually. This process is really disappointing. But when you see that the database is

Who can provide specific practice instances for the mysql high-availability architecture !!!, Mysql Architecture Currently, mysql high-availability architecture is only available in solution 4, as shown below, but there is no specific practice. Can

Install MySQL 5.6.23 and ubuntu5.6.23 in UbuntuInstall MySQL 5.6.23 in Ubuntu1. download the source code package for Linux-generic, decompress it, rename the decompressed folder to mysql, and move it to the/usr/local directory; tar-xzf

A tablespace after offline alert Log reports ORA-01135 and ORA-01110 problems, ora-01135ora-01110 This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44336789 In a recent case,

Mysql adds and deletes users, adds permissions, and mysql Permissions Create user Mysql> insert into mysql. user (Host, User, Password) values ("localhost", "test", password ("1234"); adds a user name named test and Password of 1234, however, this

How to start the Oracle Database Service and oracle Database in Windows Sometimes we may encounter database connection failures. Of course, there are many reasons for this problem, one of which is because the database service is not started. The

Oracle XE installation and oraclexe InstallationI. unmount the original databaseThe database uninstallation is not much said. Let's talk about the process: 1. Execute Oracle Uninstall, uninstall Oracle product 2, delete all Oracle related items

Sqlserver cache plan-Clear the cache plan that is only used once, And Cache The plan cache is very large and will only be cleared once using the cache plan, instead of the entire cache. declare @ sid varbinary (64) declare cur01 cursor forselect

Automated deployment of Mysql Distributed Database changes [Source Code], mysql Author: skateTime: 2015/03/05   Automatic deployment of MySQL database changes   Overview:This Mysql database publishing program can automatically, quickly, and

Create temporary tablespace group in oracle and create in oracleAfter oracle11g, you can create a temporary tablespace group. A temporary tablespace group can contain one or more temporary tablespaces.A temporary tablespace group must consist of at

Key points for connecting MySQL to php and key points for mysqlphp To operate a MySQL database, follow these steps: 1: Get the connection. 2: select the library. 3: Set the operation encoding. 4: Send SQL commands (MySQL database can be divided into

Add, delete, modify, query, and add, delete, and modifyPreface: LanguageIntegrated Query is a set of extensions for c # and Visual Basic languages. It allows you to write C # Or Visual Basic code to query memory data in the same way as a

My MYSQL Study Notes (1), MYSQL Study Notes ( This is my personal notes for learning MYSQL through online articles. I hope this will help you.1. DEFUALT keywords CREATE TABLE emp(id INT DEFAULT 12) 2. Set the auto-increment column

SAA-SQL access advisor (oracle 11.2 and later), saa-sqladvisor I recently used SAA and found that many blogs on the Internet actually have problems using it in subsequent versions after oracle 11.2, Either the version change syntax is changed or

Comparison of common functions of SQL Server and Oracle, sqlserveroracle --------- Mathematical functions1. Absolute ValueS: select abs (-1) valueO: select abs (-1) value from dual2. INTEGER (large)S: select ceiling (-1.001) valueO: select ceil (-1.0

[Translated from mos] New Features of Oracle 11gR2 relink, 11gr2relink New Features of Oracle 11gR2 relink Source:Oracle 11gR2 Relink New Feature (Document ID 883299.1) Applicable:Oracle Database-Enterprise Edition-Version 11.2.0.0 to 11.2.0.0

Call the Oracle stored procedure in java, and the javaoracle Stored ProcedureCalling the Oracle stored procedure in java This article describes how to call the stored procedure of Oracle through java.1. Write the Stored Procedure Create or replace

Five tips to easily collect SQL Server Data Sometimes you want SQL Server to return an aggregation result set, rather than a detailed result set. The GROUPBY clause of SQL Server provides a way to aggregate SQL Server data. The group by clause