Database Administrator

MySQL user database creation method MySQL user database creation method: Create a database bkjia, add a user named doiido with the password bkjia.com, and only have permissions on the bkjia database. 1. logon Method # Mysql-u root-p 2. Create a

Install MariaDB on CentOS 6.5 1. software environment:CentOS 6.5x64MariaDB 5.5.36 2. Installation Process1) Create the MariaDB. repo file in the/etc/yum. repos. d/directory. The content is as follows: # MariaDB 5.5 CentOS repository list-created UTC#

How to view the innodb version in MySQL How to view the innodb version in MySQL SELECT * FROM information_schema.plugins \ G The innodb version of mysql 5.6.3-m6 is 1.2.3. View the version method to see the major version SELECT * FROM

Fully Distributed HBase installation and Hive remote mode (MySQL as a database) Installation The first step is to complete the distributed installation of HBase. The environment for this deployment is Hadoop-1.2.1 + hbase-0.98.X. Because this

ORA-14402: updating partition keyword columns will cause partition changes By default, Oracle Partition Table for partition fields is not allowed to update the operation, if there is a forward update on the partition field, the error -- ORA-14402:

Summary of basic mysql usage and mysql usage1. Download and install Download from the official website: Http://www.mysql.com/ Note that you need an Oracle account to download it. 2. Start mysql Run the following command to install mysql: Set it

Solution to Environment variable ORACLE_UNQNAME not defined error reported by CentOS Oracle, environmentvariable After installing Oracle on CentOS today, the "Environment variable ORACLE_UNQNAME not defined" error is reported when the "emctl start

Oracle creates large file tablespaces and oracle creates SpacesLarge file tablespace is a new tablespace type introduced by oracle10g and later versions. It is mainly used to solve the problem of insufficient storage of large files. Unlike Common

Management of user permissions in the background database design, management of user permissions in the background From prism school-online IT education www.prismcollege.com 1. Create a basic table Create three tables: User, Role, and Module. each

Two effective solutions to the MySQL server has gone away problem: mysqlgone Recently, a website was designed to use the WEB page collector function. When a PHP script requests a URL, the requested webpage may be slow, exceeding the wait-timeout

[Translated from mos] Which JDBC driver version supports scan ip addresses ?, Mosjdbc Which JDBC driver version supports scan ip? Source:Which JDBC Driver Versions Support SCAN? (Documentation ID 1150835.1) Applicable:JDBC-Version 10.2.0.1 to 11.2

Mao (xml) test multiplication (2): pl/SQL method, xmlpl Oracle supports xml. You can use pl/SQL to process xml data. The following example uses dbms_output for xml processing. Similarly, you can Insert the result into the table. Declarex xmltype: =

[Oracle] Sequence object usage, oraclesequence object**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** **************

Oracle deletes users and tablespaces, and oracle deletes1. view the tablespace and its name.SQL> SELECT FILE_NAME, TABLESPACE_NAME FROM dba_data_files;2. query the user and the corresponding tablespaceSQL> select username, default_tablespace from

MySQL architecture and various file types learning summary, mysql Architecture1. mysql Architecture Composed of databases and database instances, it is a single-site multi-thread architecture. Database: a collection of physical operating system

Mysql views database objects (Summary of SQL commands) and Mysql SQLView database objects in Mysql (Summary of SQL commands)The data objects include tables, views, triggers, and so on. (To View statistics, you must enter the information_schema

Nvl function usage, nvl Function A nvl function is a null value conversion function.NVL (expression 1, expression 2)If expression 1 is null, NVL returns the value of expression 2. Otherwise, expression 1 is returned. The purpose of this function is

Windows platform listeners cannot start reporting TNS-12560 TNS-00530, tns-12560tns-00530Windows platform listeners cannot start reporting TNS-12560 TNS-00530Symptom -- 01: C: \ Users \ Administrator> lsnrctl startLSNRCTL for 64-bit Windows: Version

Oracle sets auto-start upon startup, oracle starts upon startup By default, Oracle databases in Linux do not start on their own, but many times we need to start the Database on their own, so we need to set the settings as follows: System

Create a Stored Procedure Stored in SQL Server and call C, Stored ProcedureSome compiled and optimized SQL statements placed on the database server can be directly called by the program. Using Stored Procedures has the following advantages:1.