Database Administrator

MySQL master-slave replication Structure Construction 1. Select two servers as the master and backup databases respectively. 2. log on to the server, Yum install mysql; Yum install mysql-server; 3. Start the server Service mysqld start 4. log on to

MySQL event to implement regular table creation note MySQL event to implement regular table creation note Create a table for the next day every morningDELIMITER //Create procedure test. create_tab_every_day ()BEGINDECLARE '@ I' VARCHAR (15 );DECLARE

Modify the Oracle listening address in Linux What if your server has changed its ip address?What if your server name is changed?What about old friends?What Should old customers do?It doesn't matter. You can easily modify the listening address!To

Error code: 1007 Can't create database 'test'; database exists, 1007 exists 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: create database test error code: 1007Can't create database 'test'; database exists

Summary of basic SQL knowledge and summary of SQL 1. Main Types of SQL statements (1) DDL: Data Definition Languages, Data Definition Language. Common statement keywords mainly include create, drop, alter, etc; (2) DML: Data Manipulation Language,

SQL SERVER cannot modify the table structure or column type. When using table structure design in SQL SERVER: Note: you cannot save the changes. You must delete and recreate the following tables. You have made changes to tags that cannot be

Use the command line method to log on to SqlPlus. The password contains special characters and special characters of sqlplus. All hits!It's really hard to wait! Oracle 12c. If you want to log on to SQL plus, there is no graphical interface. a

Cross join usage in T-SQL (semi-translation), t-sqlcross Suddenly I found a very hanging link. Let's take a look at what the database should do. be timid and cautious: DBA work content !!!! Today I will translate an article on T-SQL, this article

Mysql13 Copy 2, mysql13 Copy 2Replication management monitoring Show master logs;Check the second-level logs of the master database. The logname is the input parameter of other commands, and the file_size is the offset and the input

Mysql backup and Restoration1. mysqldump1.1. backup method: (1) Export the entire database and specify the character set (including data in the database) Mysqldump-u root-p -- default-character-set = utf8 dbname> storage path (2) Export the database

What is the difference between allocating undo rollback segments between mysql5.6 and mysql5.7? mysql5.6mysql5.7 1. mysql5.7 is divided into two types: Temporary tablespace rollback segments and common rollback segments. 2. mysql5.6 is not

Detailed notes on Hibernate and hibernate Add environment in the Hibernate configuration file. 1. jar package 2. configuration File hibernate. cfg. xml/xxx. hbm. xml3. use hibernate to add, delete, modify, and query Configuration cfg = new

Oracle 051 (oracle 11g), 05111g Oracle 051 questions (oracle 11g) 1. INTERVAL usage Select interval '000000' MONTH, INTERVAL '54-2 'year to month, INTERVAL '11: 12: 300 'hour to second from dual; The query result is: INTERVAL

Plsql Export and Import Export Steps: 1 tools-> export user object selection option to export the. SQL File 2 tools-> export tables-> Oracle Export select option to export the. dmp File Import steps: 1 tools-> import tables-> SQL Inserts import. SQL

Linux Command skills, linux commands[Oracle @ rh64 ~] $ Cat lgrw.txt cat: lgrw.txt: No such file or directory [oracle @ rh64 ~] $ ^ Rw ^ wrcat lgwr.txt 18:03:19. 703928 times ({tms_utime = 27, tms_stime = 18, tms_cutime = 0, tms_cstime = 0}) = 433678

Create external table in oracle and create in oracle Oracle db allows you to query External tables in read-only mode. External tables can be stored on any storage device that can be read by oracle databases. The content of external tables is not

MySQL view log, mysql Log 1. View MySQL logs mysql> show global variables like '%log%';+-----------------------------------------+-------------------------+| Variable_name | Value |+-----------------------

Restart uard method and restart uard Method-- DG restart procedure-- 1. Shut down the master databaseShutdown immediate;-- 2. Disable the standby DatabaseAlter database recover managed standby database cancel;Shutdown immediate;-- No listener. If

Mybatis Association, mybatisassociation Type = "busines. administer. cp. model. CPBookCategory">Type = "java. util. HashMap">SELECT id, name, is_parent, pid FROM cp. tbl_cp_category where pid =#{ value };]>Explanation: 1) the busines. administer. cp.

The database generates scripts with frameworks and data, and restores the database. The framework scriptWe certainly need to maintain or reconstruct the project. At this time, we need to face other people's systems. If our predecessor was a very