Database Administrator

How to forget the MySQL root Password in Windows 1. Open the MySQL configuration file my. ini and add skip-grant-tables to the end of the file or add it to the [mysqld. 2. Restart the MYSQL service. In windows:Net stop MySQLNet start MySQL If an

MongoDB Study Notes (2)-basic connection example between Node. js and MongoDBPrerequisites Node. js and MongoDB have been installed. The node. js used in this article is v0.12.0 and MongoDB is 3.0.0. MongoDB Study Notes (1)-install MongoDB on

Install MariaDB (MySQL) on CentOS 6.5) Install MariaDB (MySQL) on CentOS 6.5) 1. Get the installation package of mariaDB from the official website and put it under the root directory through xftp. 2. Expand the MariaDB File Tar xf

Parameter Adjustment when deploying MongoDB Deploy the MongoDB production server and give the following suggestions: Use a virtualized environment; System Configuration 1) recommended RAID configuration RAID (Redundant Array of Independent Disk,

Restore the backup set created by mysqldump Restore the backup set created by mysqldump: SQL format recovery Create a table structure first Method 1: [Mysql @ mysql1 ~] $ Mysql-usystem-p123456-S/data/mysqldata/3306/mysql. sock hugc Method 2:

A ORA-03262 is reported when an empty datafile is deleted from tablespace Reference: Cannot Drop Empty Datafile From Tablespace ORA-03262 (Document ID 1353029.1) Applicable: Oracle Server-Enterprise Edition-Version: 11.2.0.2 and later [Release: 11.2

Basic SQL internal connection and external connection, basic SQL connection Some problems have been depressing for a long time. For example, why is there a connection between the left and right sides? If the foreign key is empty, the foreign key

Explanation of database paradigm and explanation of database paradigm Database paradigm 1NF 2NF 3NF BCNF (example) The design paradigm (paradigm, database design paradigm, and database design paradigm) is a set of relational patterns at a certain

Oracle 12c 3 pdb pluggable test, 12 cpdb DECLAREl_result BOOLEAN; BEGINl_result: = partition (pdb_descr_file => '/u02/pdb/pdb3.xml', pdb_name => 'pdb3'); IF l_result THENDBMS_OUTPUT.PUT_LINE ('compuble '); ELSEDBMS_OUTPUT.PUT_LINE ('compatible ');

Oracle 12c learning 3 converting nocdb to pdb and nocdbpdb 01:23:06 sys @ orcl> select name, decode (cdb, 'yes', 'multitenant Option enabled', 'regular 12c Database: ') "Multitenant Option", open_mode, con_id from v $ database; NAME Multitenant

14. Search Overview and sequential search, and 14 Search Overview order1. Search Overview1. Search:That is, a data element (or record) whose keyword is equal to the given value is determined in the search table based on a given value ). If the table

Group by, improve SQL running speed, groupsql Data Table dh_order_detail contains a total of 169247 data records. Original SQL SELECTFROM_UNIXTIME (order_time, '% H: % I') 'time', city, district, LEFT (company, 6) company, goods_num,

Before dropping a user, we recommend that you obtain the user's dependency. Before deleting these two users, we recommend that you obtain their dependencies: SQL> col owner format a15SQL> col name format a15SQL> col REFERENCED_NAME format a30SQL>

Oracle object type Oracle object typeObject Type In PL/SQL, object-oriented programmers are based on object types. The object type is a user-defined Composite data type. It encapsulates the data structure and processes and functions used to

CBO Full Table Scan, cbofulltablescan Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44261859 **************************************** *******I. Full Table Scan-FTS algorithm of CBO*********************************

Javaee-jdbc, javaee 1. First import the jdbc-mysql package 2. Program Framework: 3. Database Configuration File Driver = com. mysql. jdbc. DriverUrl = jdbc: mysql: // localhost: 3306/jdbc_dbUsername = rootPassword = 1234 4. Access the underlying

Oracle views the properties of a tablespace, modifies the tablespace status, and oracle viewsThe status attributes of a tablespace mainly include online, offline, read only, and read write, the read-only and read/write statuses are special online

Mysql char varchar blob text performance details, varcharblob Char Fixed Length, up to 255 bytes. If the storage space is not full, a space will be filled on the right side of the data. Varchar The maximum length is 65536 bytes. When the varchar

Modify instance SID in Oracle and instance sid in oracleModify the ORACLE Instance nameSystem Environment: CentOS 6.5ORACLE version: 10.21. Check the original database instance name$ Echo $ ORACLE_SIDOrcl$ Sqlplus/as sysdba> Select instance from v $

Atitit. automatically generate a database structure script or change the database, based on hibernate4, atitithibernate4 Atitit. automatically generate the database structure script or change the database, based on hibernate4   Current situation ::