NAV: SLTechnology News&Howtos > Database >

• 

  Oracle11g installation based on linux 6.3

  Installation package: p13390677_112040_Linux-x86-64_1of7.zipp13390677_112040_Linux-x86-642of7.zip2.Configuring global parameters: 1.Configuring orac

  2022-06-01 10:18:16 Views: 245
• 

  Oracle cannot be used after centos7 changes the machine name

  1. Change the machine name ~] # hostnamectl-static set-hostname oracle2, ~] # su-oracleLast login: Tue Apr 12 10:11:3

  2022-06-01 10:17:53 Views: 217
• 

  PowerDesigner export

  Export: step 1: step 2: select Model types-Phslcal Data Model-Physical Diagram Select DBMS:MYSQL (depending on the database) step 3: configure connection step 4: set connection

  2022-06-01 10:17:53 Views: 228
• 

  Oracle gets the first piece of data

  An example of sql for fetching the first piece of data is as follows: http://www.360doc.com/showweb/0/0/860281883.aspxSELECT * FROM tableName where

  2022-06-01 10:17:39 Views: 264
• 

  Read-write separation of Mysql database

  First, the database operations are separated from reads and writes, so that the master server with the role of master is mainly used to perform write operations, which can greatly reduce the overload of the main server caused by read operations. Read it to slave. For multiple read servers, the pressure of the read operation should also be shared.

  2022-06-01 10:17:25 Views: 251
• 

  Awk command learning

  Awk is a line processor: compared with the advantages of screen processing, there is no memory overflow or slow processing when dealing with large files. It is usually used to format text information awk processing process: each line is processed in turn, and then output awk command form: awk [- F |-f

  2022-06-01 10:17:24 Views: 240
• 

  MySQL 5.7 change your password after you forget it

  1. Modify login settings vim / etc/my.cnf # or / etc/mysql/my.cnf [mysqld] skip-grant-tables # add 2, restart mysql service 3, log in directly to mysql

  2022-06-01 10:17:23 Views: 298
• 

  Oracle sysman account modification EM cannot enter the problem

  You only need the following steps to oracle@DB-MASTER-1 ~] $emctl setpasswd dbconsoleOracle Enterprise Manager 11g Database Contr

  2022-06-01 10:17:23 Views: 277
• 

  Mysql Audit tool archery

  Mysql Audit tool archery system: Centos6.8ip:192.168.122.150 installation Python and virtualenv compilation installation [root@www ~] # yum install wget

  2022-06-01 10:16:59 Views: 233
• 

  Ansible-- Foundation

  Brother Ma produced ansible Chinese document: http://www.ansible.com.cn/index.htmlansible introduction: what is ansible? The official title is "Ansible is S"

  2022-06-01 10:16:59 Views: 244
• 

  Zabbix3.2 super-detailed building process + email alarm mechanism

  Change the address of the blog to www.qxfell.comZabbix:zabbix 3.2Linux: CentOS 7Yum Source: 163epel any one of them can be 163wget http://mirrors.16

  2022-06-01 10:16:29 Views: 217
• 

  Nginx service deployment

  Author: Georgekai Archive: study Notes 2018/2/2nginx Service deployment 1.1 Common web Software understanding 1.1.1 web Service mainstream Software address https://w3techs.com/technologies/o

  2022-06-01 10:16:24 Views: 215
• 

  The realization method of legal check function of SqlServer2000 ID Card

  This article mainly explains the implementation of the legal check function of SqlServer2000 ID card, the content is clear and clear, interested friends can learn, I believe it will be helpful after reading. Let's take a look at the code for sqlserver2000 ID card verification.

  2022-06-01 10:16:23 Views: 245
• 

  Learning materials for php+mysql+jQuery

  I have the relevant php+mysql+jQuery learning materials here, want friends to add me Wechat: lqs370506942

  2022-06-01 10:16:23 Views: 270
• 

  Using metadata to analyze databases in Java Foundation Series 15:JDBC

  (1) DatabaseMetaData:package javase.jdbc;import java.sql.Connection;import java.sql.DatabaseMetaData

  2022-06-01 10:16:23 Views: 279
• 

  Installation and configuration of MySql database

  Download the http://dev.mysql.com/downloads/mysql/ official website, as there is no 32-bit option to download the 64-bit version, install and configure the following screenshot steps

  2022-06-01 10:15:53 Views: 269
• 

  MariaDB10.2.6 enables Mroonga storage engine for full-text indexing

  As translated, Mroonga is a storage engine for MySQL. It provides a fast full-text search function for all MySQL users. Here is a direct demonstration of how to enable the mroonga storage engine on MariaDB 1) load the mroonga plug-in M

  2022-06-01 10:15:53 Views: 234
• 

  Xtrabackup backup and restore MySQL database

  1. Full backup recovery: check the contents of the original table: MariaDB [(none)] > select * from testdb.students;+----+

  2022-06-01 10:15:44 Views: 292
• 

  Three installation methods of MySQL5.7 version

  Installation of mysql5.7 MySQL can be divided into three ways: {1; source code compilation, 2; binary installation, 3 MySQL rpm installation} 1, main features: native support Systemd better performance: for multi-core CPU, solid state disk, lock

  2022-06-01 10:15:44 Views: 249
• 

  Mysql modifies database information through the command line

  1. Syntax: ALTER DATABASE database name CHARACTER SET encoding COLLATE proofreading rule 2. Syntax parsing: database name: demo1 code: one of the code sets such as utf8 proofreading rules: one of the proofreading rule sets such as ut

  2022-06-01 10:15:37 Views: 217