NAV: SLTechnology News&Howtos > Database >

• 

  Three disciplines and seven points for attention (Access database)

  The three major disciplines (rules or paradigm) must have primary keys, other fields depend on primary keys, and other fields cannot rely on one table and one primary key (order table: order number; order schedule: order number + product number). Small data (date, number type) fields do not appear in other tables (multiple

  2022-06-01 09:51:04 Views: 218
• 

  Python link to mysql database

  Import MySQLdbconn=MySQLdb.connect (host='127.0.0.1',user='root',passwd='123456',db='08day5') cur=conn

  2022-06-01 09:51:04 Views: 237
• 

  Self-increment implementation of oracle column

  1.Sequence+Trigger implements Oracle column to add CREATE SEQUENCE sequence name [INCREMENT BY n] [START WITH n] [{MAXVALUE/MINVALUE n |

  2022-06-01 09:51:04 Views: 207
• 

  Introduction to manual database chain in section 7 of Oracle learning notes

  Select * from vault circle; check the logical circuit and share the server connection. If you use easy connect, you will display select * from vault circle; generally configure three sqlplu

  2022-06-01 09:51:04 Views: 284
• 

  Must understand the concept of optimization-cardinality

  1. The number of unique keys in a column is called cardinality. 2. For example, the gender column is divided into men and women only, and the cardinality of the so column is 2. 3. Test SYS@orcl > select count (distinct owner), count (distin)

  2022-06-01 09:51:03 Views: 290
• 

  Summary on the usage of query in expdp

  Today, I saw someone in the group asked about the solution of using the query parameter to report errors in exporting data using expdp. I also messed around out of curiosity. Now record as follows. On the first attempt, [oracle@DB ~] $expdp scott/s

  2022-06-01 09:50:45 Views: 290
• 

  Mysql real environment building master-slave

  Mysql real environment building master-slave security code: the reason why people can, is to believe that can. Nowadays, there are many kinds of databases, such as oracle mysql SQL Server ACCESS, etc. Today we come to the real environment to build mysql master and slave. Let's talk about four kinds of numbers first.

  2022-06-01 09:50:22 Views: 292
• 

  Getting started with Oracle Database

  1. Oracle1, oracle service 1) OracleDBConsoleorclOracle database console service. Orcl is the instance ID of Oracle. The default instance is orcl. 2) OracleOraDb11g_h

  2022-06-01 09:50:18 Views: 295
• 

  SQL-- what is a transaction? What are the characteristics of transactions?

  A conceptual transaction (Transaction) is a program execution unit (unit) that accesses and possibly updates various data items in a database. Transactions are usually caused by the execution of user programs written in high-level database manipulation languages or programming languages, such as SQL,C++ or Java, and using the

  2022-06-01 09:50:18 Views: 247
• 

  Mysql backup and recovery + ERROR 1046

  Mysqldump-uroot-p123456-- default-character-set=utf8 quan > / opt/quan.sql / / backup grep-Ev "# |\ / |-- | ^ $

  2022-06-01 09:50:18 Views: 205
• 

  Summary of oerr tool usage

  Oerr can query the meaning of short error messages on Linux and UNIX operating systems, which can assist in troubleshooting Oracle faults. How to use 1.oerr [oracle@BJS ~] $oerr ora 1257112571

  2022-06-01 09:50:17 Views: 234
• 

  [Oracle Database] Oracle RAC (8): service resource management

  Service resources each database has one or more service names, and the service name is the name provided to the client to connect to the database instance. Creating a database creates a service with the same name as the database by default, and the default service implements all instances

  2022-06-01 09:50:17 Views: 211
• 

  Redis-- persistence RDB and AOF principle

  There are two kinds of redis persistence methods: RDB snapshot and AOF mode (default is RDB mode). When the Redis server is restarted, the data will be recovered automatically, first from AOF, and then from RDB. 1. RDB snapshot mode RDB mode principle:

  2022-06-01 09:50:17 Views: 227
• 

  Python connection mysql

  # coding=utf-8import MySQLdbdb= MySQLdb.connect ("127.0.0.1", "root", "tvc123456", "bigdata_content") curs

  2022-06-01 09:50:17 Views: 230
• 

  Construction of Oracle 11G R2 Dataguard under CentOS 5.11

  Datagard is a disaster recovery solution of Oracle Enterprise Edition, which is widely used in enterprises, so I will record the building process as a backup. Hostname database version instance name IPdb1 Oracle 11G R2 member 172.16.

  2022-06-01 09:50:17 Views: 249
• 

  Lock data rows for update and for update nowait

  Lock the data row select * from emp t where t.deptno='20'for update nowait; so that the row of deptno= 20 data in the emp table is locked Note: through for up

  2022-06-01 09:50:16 Views: 273
• 

  Oracle primary keys and constraints

  The Oracle primary key Primary Key contains non-null and unique constraints. Add the statement alter table table_name add constraint cons_name primary key (co) of the primary key

  2022-06-01 09:50:16 Views: 242
• 

  Oracle- dictionary

  Oracle data dictionary, is the storage of database-related information data. When creating a table, a space, user access rights, and so on, they are saved in dictionaries to provide future search convenience. Data dictionaries are divided into two categories: 1. Static dictionaries are mainly tables and views user_* that save users.

  2022-06-01 09:50:16 Views: 220
• 

  RedHat 7 silently install Oracle 12c

  After reading a lot of Oracle silent installation tutorials on the Internet, I felt a bit messy. After consulting the Oracle official website English manual, combined with the installation test in the virtual machine, I sorted out this RedHat 7 silent installation Oracle 12c. Redhat 6 Silence

  2022-06-01 09:49:45 Views: 277
• 

  Oracle 11g R2 installation and configuration

  -- = 0: XServer is ready to install XServer, configure XShell--Xming,Xmanager,Vcxsrv--= 1: disk partitioning and mount cd / etc/y

  2022-06-01 09:49:45 Views: 248