NAV: SLTechnology News&Howtos > Database >

• 

  Database MYSQL Learning Series 1

  Database MYSQL Learning Series I. MySQL Database Foundation 1.1-recognize what is a database MYSQL all the information processed and stored by a computer is a program for accessing data in a data computer system: there are many programs in a computer system that can access data.

  2022-06-01 10:36:22 Views: 225
• 

  ORACLE stored procedure loop table operation

  CREATE OR REPLACE PROCEDURE pubres_testasBEGINfor obj in (select resource_name,unit_name,resource_co

  2022-06-01 10:36:22 Views: 244
• 

  Mysql uses union all query to count the total quantity

  Select sum (A.B) as num from (select count () as b from table_1union allselect count () as b from table

  2022-06-01 10:36:21 Views: 275
• 

  Centos 6.5 install mysql in one minute

  Centos 6.5. install mysql in one minute and execute wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpmrp manually

  2022-06-01 10:36:21 Views: 268
• 

  Database security management

  1. Oracle authentication method Oracle authentication mainly has the following ways: operating system authentication password file authentication database password authentication external authentication network authentication, operating system authentication and password file for administrator account; external authentication is similar to operating system

  2022-06-01 10:36:21 Views: 266
• 

  Database-indexes, triggers, transactions (storage engine)

  Database-the main features of a warehouse that organizes, stores and manages data according to the data structure: data sharing; reduction of data redundancy; data independence; data centralized control; data consistency and maintainability, to ensure the security and reliability of data; fault recovery. two

  2022-06-01 10:36:20 Views: 227
• 

  What if oracle forgets his password?

  For a database, it will be troublesome if the administrator forgets the password, so let's see how to change the password. Log in to cmd and enter sqlplus/nolog2. Enter conn/as sysdba3. Modify password administrator

  2022-06-01 10:36:20 Views: 205
• 

  Rman backup script shell version

  1. Complete database to hard disk [oracle@centos7 scripts] $cat rman_backup.sh source / home/oracle/.bash_profile rman targ

  2022-06-01 10:36:05 Views: 246
• 

  Dell R720 Server CPLD version: 103

  I have a Dell R720 server here at work, and I find that as long as it is rebooted, it will not be able to enter the system, as shown in: CPLD version: 103Managerment engine Mode: ActiveManagerment

  2022-06-01 10:36:05 Views: 213
• 

  Linux file lookup

  Linux File Lookup details the grep, egrep, and fgrep commands we've learned before are Linux text lookup commands, which simply match strings, not file lookups. A commonly used command for file lookup: 1 _ field _ locatev _ blank

  2022-06-01 10:36:05 Views: 273
• 

  [oracle11g] overall startup and shutdown

  1. Close the database [default orcl] sqlplus / nologconn sys/sys as sysdba;shutdown immediate;-- close all instances of lsnrctl stop2. Off alone

  2022-06-01 10:36:04 Views: 287
• 

  Manual import and export of innodb

  The previous article introduced "innobackupex hot backup specified database table operation" and analyzed the whole process, that is, the principle of exporting table dictionaries and data files to import. Then for the backup and recovery of a single table (restore in a new instance or new library), we can directly use physical export in.

  2022-06-01 10:36:04 Views: 230
• 

  Ways to deal with several minor problems encountered by SQL2008

  -sql server 2008 Evaluation overdue solution-HKEY_LOCAL_MACH

  2022-06-01 10:36:04 Views: 231
• 

  Installing oracle 11g Database under Linux (1)

  Minimum memory requirements for installing oracle 11g database (1) 1 under Linux: 1 GB of RAM recommended configuration: 2 GB of RAM or more determine memory size, enter the following command: grep MemTota

  2022-06-01 10:36:03 Views: 256
• 

  MySQL 5.7password Policy

  In MySQL version 5.7, user password policies are divided into low-level LOW, medium MEDIUM and super-strong STRONG, and medium MEDIUM level is recommended. When we install MySQL, we set the user password policy with the following command: shell >

  2022-06-01 10:36:03 Views: 205
• 

  How does Oracle find out which table the foreign key is built on?

  How to check which table the foreign key is built on sometimes when deleting a table record, it will report an error that the foreign key constraint cannot be deleted. If you don't know the relationship between tables, you can query the table on which the foreign key is built by using the following statement: select * from dba_constraints

  2022-06-01 10:36:00 Views: 211
• 

  MMM Architecture Scheme and implementation

  MMM architecture scheme and implementation of MMM, namely Master-Master Replication Manager for MySQL (mysql Master replication Manager), is a set of monitoring, failover and management of mysql master replication configuration

  2022-06-01 10:35:50 Views: 217
• 

  Decompose a string into a table (multiple rows, multiple columns) table-valued functions [StrSplit_Tab]

  Use a string to describe the contents of a table and use this table-valued function to restore it to a table if needed. Because it is impossible to predict the number of columns and column names of the table, [column conversion] is performed when needed. This function, like the [StrSplit] function, can also decompose a string into a single column, as long as

  2022-06-01 10:35:49 Views: 231
• 

  P2P house-the construction of a large file distribution network

  In June, I went to Shanghai to attend the container conference organized by DockOne. I signed up for a small project and accidentally won the first prize. Here, I would like to share with you the construction of the core P2P transmission network, which is also a large file transfer method that the company has put into use. Project design: original intention: 1.

  2022-06-01 10:35:44 Views: 239
• 

  Beginners to learn the three functions of Oracle UNPIVOT,PIVOT,WMSYS.WM_CONCAT

  Recently have been exposed to Oracle UNPIVOT,PIVOT,WMSYS.WM_CONCAT, so as not to forget, organized as follows:-- the use of UNPIVOT

  2022-06-01 10:35:26 Views: 252