NAV: SLTechnology News&Howtos > Database >

• 

  Control file and database initialization

  The control file is the database brain, and the system tablespace is the heart of the database SQL > alter session set events' immediate trace name controlf level 8 databases

  2022-06-01 07:31:17 Views: 281
• 

  Master-Slave Construction based on GTID

  Note: what is built here is one master and multiple slaves. Environment: centos7+MySQL5.7 Master: 192.168.162.134 install from 1rig 192.168.162.133 from 2rig 192.168.162.135 reference: http://li

  2022-06-01 07:31:09 Views: 268
• 

  DNS- source code for CentOS6 service management installs Bind-9.10

  Source code installation bind1. Prepare the source code package: bind official website: http://www.isc.org/downloads/bind/[root@dns1 ~] # ll-rw-r--r-- 1 root root 83

  2022-06-01 07:31:09 Views: 253
• 

  Ftp realizes virtual user authentication through database

  First, install the required program 1. Install the package [root@fsy-Centos6 ~] # yum install vsftpd2 required for the ftp service. Install MySQL database: [root@fsy-Centos6 ~] # y

  2022-06-01 07:31:08 Views: 200
• 

  Database Management tool Navicat Premium tutorial: several important

  Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases simultaneously with a single program, making it more convenient to manage different types of databases. The data are many large and small.

  2022-06-01 07:31:00 Views: 241
• 

  MYSQL Enterprise applications (2) Architecture

  2.1 MYSQL service structure mySQL is a typical cplink mode, which is composed of server and client. Server: mysqld client: mysql client comes with programs: mysql,mysqladmin,mysqldump and other 2.2m

  2022-06-01 07:30:54 Views: 278
• 

  05 data manipulation language

  1 data manipulation language data manipulation language for retrieving, inserting and modifying data manipulation language is the most common SQL command data manipulation language commands include: SELECT query INSERT add UPDATE modify DELETE delete 2 SELECT command

  2022-06-01 07:30:51 Views: 232
• 

  Oracle Study-- hosts file failure of Oracle 11gR2 building RAC

  Oracle Study-- Oracle 11gR2 builds hosts file failure system environment for RAC: RedHat EL55Oracle: Oracle 11gR2 + GI is installing GI and running root.sh sc

  2022-06-01 07:30:51 Views: 274
• 

  Oracle ebs finds users through responsibilities

  SELECT DISTINCT papf.person_id,papf.employee_number,papf.full_name,su.user_id,res.responsibility_id

  2022-06-01 07:30:50 Views: 239
• 

  There is no change after operation on the database in PL\ SQL

  Problem description: after adding, deleting and changing the database in the SQL WINDOW of PL\ SQL, it does not change in other command windows: the operation of adding, deleting and changing the database in SQL WINDOW is temporary and requires COMMIT to take effect, but

  2022-06-01 07:30:50 Views: 256
• 

  SqlServer series notes-common functions

  Aggregate functions: MAX (maximum), MIN (minimum), AVG (average), SUM (and), COUNT (quantity) ABS (): find the absolute value. CEILING (): rounds to the largest integer. 3.33 will be rounded to 4, 2.89 will be rounded

  2022-06-01 07:30:50 Views: 204
• 

  Use T-SQL statements to manipulate data tables-update data

  Update the data in the table using the update statement. That is, modify the data in the table. Update syntax format: update < table name > set < column name = update value > [where < update condition >] explanation: update is the update data name, indicating that

  2022-06-01 07:30:50 Views: 231
• 

  Several methods of deleting Table by Oracle

  Drop table books; 's instructions will put the form in the Recycle Bin, which can be recovered with flashback table "BIN$1Oiy3qm/QJubov1BwBUOgw==$0" to before drop;.

  2022-06-01 07:30:49 Views: 250
• 

  Installation and configuration of postgresql source code

  It is very easy to install postgresql. It's a direct trilogy. . / configure-- prefix=/usr/local/postgresqlmakemake install creates the data directory m of postgresql

  2022-06-01 07:30:34 Views: 234
• 

  Mongo code 96

  Mongodb: Sort operation used more than the maximum 33554432 bytes of RAM1 mongo query data for paging, in some cases or in some cases

  2022-06-01 07:30:34 Views: 279
• 

  Hibernate frame relation mapping

  I have been in contact with Hibernate for a short time, and I feel more and more that Hibernate is a magical thing. Why do you say so? Because you can not understand a line of sql, directly object-oriented, you can directly save the data to the database! You can also save an object, but

  2022-06-01 07:30:34 Views: 232
• 

  Detailed explanation of list and report commands of RMAN

  List command RMAN's list command is a way to query backup history information in a database control file or recovery directory. 1. List counterpart command: list incarnation function: provide the user with a list of database counterparts for each target database

  2022-06-01 07:30:33 Views: 240
• 

  The server time zone value

  Exception description Exception in thread "main" java.sql.SQLException: The server time zone value'? host ±exception Is u

  2022-06-01 07:30:30 Views: 290
• 

  Python object-oriented advanced programming-using enumerations and metaclasses

  1.1 enumerations based on Enum class implementation using enumerations > fromenum import Enum > Month = Enum ('Month', (' Jan','Feb', 'Mar',' Apr','M)

  2022-06-01 07:30:30 Views: 213
• 

  Windows10 installation Mysql5.7.19.0 msi version error

  Installation environment: Windows10 installation version: MySql 5.7.19.0 msi1. Install 5.7.19.0 msi version of Mysql Times with the following error: 2. According to log analysis, visual Studio 2013 Red is missing.

  2022-06-01 07:30:25 Views: 204