Database Administrator

Comparison and learning between MySQL and Oracle The storage engine in MySQL is very rich, commonly used include InnoDB, MyISAM, and so on. I also read a lot of information and have some knowledge about it, from some reference books, I can see that

How to Create a LocalDB database and database instance LocalDB is a new feature of SQL Server 2012. It is a lightweight database tailored for developers. The following describes how to use it. How to Create a LocalDB database: Open the Server

Several parameters behind the Truncate data table The Truncate statement is a distinctive one in the Oracle SQL System. The direct effect of Truncate is to clean up data in the data table. It is a typical DDL statement at a deeper level. In Oracle,

Oracle startup error ORA-03113 resolution Environment: RHEL6.4 + Oracle 11.2.0.4 Step summary:1. Start error ORA-031132. view the alert Log to find the cause3. Take reasonable measures according to the actual situation. Here we first increase the

Error Code: 1305. FUNCTION student. rand_string does not exist, randstring 1. Error description 13: 52: 42 call new_procedureError Code: 1305. FUNCTION student. rand_string does not exist0.000 sec 2. Error cause Create definer = 'root' @

Windows Oracle ODBC installation configuration, oracleodbc Environment: Windows 7, 32-bit OS 1. Download the driver package The official Oracle website can be downloaded.Base package: instantclient-basic-win32-10.2.0.4.zipOdbc package: instantclient-

Oracle learning Summary (1), oracle learning Summary1. Installation and download of oracle 1.1 oracle service: oracle listening service (OracleOraDb11g_home1TNSListener): it must be enabled to access the database through a program.Oracle instance

JDBC obtains metadata DatabaseMetaData, databasemetadata Package org. data. jdbc; import java. SQL. connection; import java. SQL. databaseMetaData; import java. SQL. driverManager; import java. SQL. preparedStatement; import java. SQL. resultSet;

Read consistency analysis: undo, read consistency: undoThe following uses the consistent read Analysis of undo:[Oracle @ localhost ~] $ Lsb_release-LSB Version: core-3.1-ia32: core-3.1-noarch: graphics-3.1-ia32: graphics-3.1-noarchDistributor ID:

Select from update row implementation, updaterow At the DTCC conference, Alibaba's speech mentioned: select from update hot row; I don't understand how to implement it in Oracle. It means to implement the update and select update field information

Bat starts the oracle local service, and bat starts the oracle service Oracle local services are enabled by default, occupying computer resources, affecting the boot speed. It is cumbersome to enable and disable each time. The following is a

The best way to obtain data from one table that is not in another table (Study on the Efficiency of JOIN and EXISTS) is as follows:Business Requirements: The company has a CRM broker management system. The most difficult problem encountered the day

(10) mysql variables and 10 mysql Variables Define Variables Syntax: declare var_name[,...] type [default value]; MYSQL variable definitions can only be defined in stored procedures or functions, unlike Oracle/SQL Server. This variable can only be

Database optimization tutorial (8) under what circumstances should indexes be used and indexes be optimized?Iii. Index 5. Under what circumstances should indexes be used? Since the index has a cost, you should not use it without using the

Mysql Master Slave Config, mysqlslave Install two or more MySQL services on the same machine: Download the mysql installation package. After the installation is complete, copy multiple copies of the installation folder on the disk. Enter my. ini

(7) design and use of mysql indexes and mysql index design Overview The distinct index is used to quickly find rows with a specific value in a column. If no index is used, MySQL must start with 1st records and read the entire table until related

Install mysql and machomebremysql in homebre on MAC 1. Execute the installation command Brew install mysql 2. The following bug occurs when mysql is input. ERROR 2002 (HY000): Can not connect to local MySQL server through socket

BI-SSAS practice, bi-ssas practice As the saying goes, "I have to get to the bottom of the paper, and I know that this is something to do." in the previous article, I briefly introduced SSAS, so today I will use an instance to understand its sense

MongoDB BASICS (add, delete, modify, and query) 1. Insert The insert Statement of MongoDB is in the following format: db.collection.insert(document) Document is the document data, and collection is the collection of document data. If the collection

. Net connection mysql database statement,. netmysql Database In my project, write the Connection database statement in the configuration file: Database is the database name, Data Source is the server address of the database, "localhost"