NAV: SLTechnology News&Howtos > Database >

• 

  The problem of showing only "year-month-day" when the date is displayed in the database

  The date time actually stores the year-month-day hour: minute: second, but only displays the year-month-day, not the hour minute and second information. Solution: tools-preferences-Database "NLS date format: YYYY-MM-DD HH24:MI:SS, re-query after saving.

  2022-06-01 07:32:24 Views: 289
• 

  I have to tell you the principle of MySQL optimization 3

  Talk about MySQL configuration. Most developers may not pay much attention to the configuration of MySQL, after all, when there is no problem with the basic configuration, it is a very pragmatic strategy to pay more attention to schema design, index optimization and SQL optimization. At this time, if more efforts are made to optimize the configuration

  2022-06-01 07:32:24 Views: 286
• 

  The basis of SQL Server- expression

  Table expressions do not have any physical instantiation, they are virtual when querying table expressions, and internal queries are not nested, in other words, external and internal queries are merged directly into a query of an underlying object. the benefits of using table expressions are usually related to the logical aspects of the code, but to the code

  2022-06-01 07:32:24 Views: 224
• 

  Typical questions such as WeX5 objective question Software Development and list component Application

  Interface implementation, whether WEX or BEX, the development of a variety of objective question modules are the most common. Recently, however, I ran into trouble when I tried to develop a small objective question system for students in my spare time. First of all, a large number of similar questions were found on the forum. The problem is either too simple or too special.

  2022-06-01 07:32:18 Views: 273
• 

  Introduction to MySQL default database

  Similar to large databases such as MS SQL Server, the MySQL database also provides built-in databases, which are: INFORMATION_SCHEMAmysqltest1.information_schema, the first number

  2022-06-01 07:32:18 Views: 253
• 

  Construction of MHA

  1. Environmental preparation: DB:mysql-5.7.16MHA:mha4mysql-manager-0.56.tar.gz, mha4mysql-node-0.56.tar.gz, daemontools-0.76.

  2022-06-01 07:32:17 Views: 203
• 

  Oracle user creation and Authorization (1)

  1. Enter user name: sys as sysdba2, enter password: 1234563, create user: create user admin identified by admin;4, authorization establishment table: grant crea

  2022-06-01 07:32:17 Views: 230
• 

  Mysql paging query

  Paging query: one page display is incomplete, need to page submit sql request select query list from table name ~ join table 2on connection condition where filter condition group by grouping field having condition or

  2022-06-01 07:32:17 Views: 274
• 

  Redis persistent configuration (rdb,aof)

  There are two ways to persist Redis: 1 Snapshot 2 is the configuration option for log Rdb snapshots (snapshots in memory are written to disk faster) configuration file: save 9001 / / 900s, 1 write, snapshot save 300 1000 /

  2022-06-01 07:32:17 Views: 240
• 

  Basic knowledge of mongodb Cluster

  Three ways of building http://blog.csdn.net/luonanqin/article/details/8497860 Mongodb cluster NoSQL = Not Only SQL mongodb storage

  2022-06-01 07:32:16 Views: 249
• 

  Mysql version 5.6 binary installation

  Author: Li Qiang reference: man,info,magedu handout, omnipotent internet experimental environment: VMware ®Workstation 12 Pro, Centos 6.9 centos

  2022-06-01 07:32:16 Views: 265
• 

  Struts + Hibernate + Spring WEB framework

  Struts: responsible for the display layer, is a perfect MVC implementation, it calls the business layer to complete the operation logic, and the business layer calls the persistence layer to read and write the database. Hibernate: create a series of persistent classes and map the properties of each class to the properties of the database table one by one. Spr

  2022-06-01 07:32:16 Views: 231
• 

  Db2 v11 is installed on redhat7

  1. Set hostname and modify / etc/hosts consistent hostnamectl-- static set-hostname db2v112, install operating system dependency package yum install libstdc++.so.63

  2022-06-01 07:32:16 Views: 212
• 

  SqlServer Series Notes-stored procedures

  Stored procedure-just as the definition of a method (function) running in a database is a set of precompiled SQL statements that complete a specific function, an object stored on the server can be called through the object name and the method in C#, it is composed of stored procedure name / stored procedure parameters / can have a return result. Front

  2022-06-01 07:32:15 Views: 268
• 

  Mycat connection pool model source code

  PhysicalDBNode is the counterpart of Mycat cluster (Datanode). It refers to a connection pool object PhysicalDBPool,PhysicalDBPool, which refers to the real connection pool object PhysicalD.

  2022-06-01 07:32:15 Views: 216
• 

  Types, variables and structure of PLSQL

  1. Types are described in detail about the basic data types of Oracle in the article ".net programmer Oracle Series (5): three big data types". It is also mentioned that in addition to the basic data types, Oracle also supports some non-inherent numerical types. Things

  2022-06-01 07:32:15 Views: 268
• 

  Oracle deletes spaces, carriage returns, and specified characters in the field

  Create or replace procedure PROC_test is-- Description: delete the specified characters in the field (carriage return chr (13), line feed chr (10))-- By LiChao

  2022-06-01 07:32:15 Views: 265
• 

  Database integrity check

  In order to actively find the corruption of the side pages of the database and ensure the logical and physical integrity of the database, it is planned to execute DBCC CHECKDB on all systems and user databases on the production main database at 6: 00 a.m. every Saturday, and record the results in the table. The following is the theoretical basis: SQL Server data

  2022-06-01 07:32:14 Views: 230
• 

  COST calculation of full table scan

  SQL > create table test as select * from dba_objects where 1: 0; Table created.SQL > alter table test p

  2022-06-01 07:32:14 Views: 233
• 

  Mysql sub-database and sub-table backup

  1. Backup database mysqldump-uroot-poldboy oldboy > / opt/oldboy.sql the simplest backup 1) mysql is based on myisam engine mysqldump-uroot

  2022-06-01 07:32:14 Views: 271