NAV: SLTechnology News&Howtos > Database >

• 

  The concrete method of setting MySQL character set

  This article is mainly about the specific methods of setting the MySQL character set, if you are interested, let's take a look at this article. I believe that after reading the specific methods of setting the MySQL character set, it is of some reference value to everyone. Character set introduction gbk/gb2312gbk

  2022-06-01 17:59:01 Views: 293
• 

  OGG operation and maintenance optimization script (9)-query maintenance class-process duplicate table check

  Path: $HOME/ggscript/ggrepeat function: this script is designed to deal with the problem of data duplication on the target side due to the repeated configuration of the source table on the source side. You can check the repeatedly configured table name for the process, and list the specific information and the number of file lines to match.

  2022-06-01 17:59:00 Views: 274
• 

  Method 2 for dealing with Zabbix historical database-partitioning with MySQL table

  An application scenario description http://john88wang.blog.51cto.com/2165294/1770582 described earlier that historical data can be processed by creating a new table, then importing data within a month into the new table, and finally deleting the old table.

  2022-06-01 17:59:00 Views: 243
• 

  How to disable rowid to optimize SQLite database

  How do I disable rowid tuning SQLite databases? I believe that most people have not yet learned this skill, in order to let you learn, to give you a summary of the following content, do not say much, let's move on. 1. 0 introduces that by default, every row in the SQLite database has a

  2022-06-01 17:59:00 Views: 232
• 

  PostgreSQL-the most complete string and date formatting function

  Format string and date each other function returns type description example to_char (timestamp, text) text converts the timestamp into a string to_char (current_timestamp, 'HH12:MI:SS)

  2022-06-01 17:59:00 Views: 292
• 

  Query oralce ebs requests

  SELECT REQUEST_ID,a.user_name,f.ACTUAL_START_DATE DATE_STARTED,DECODE (TRUNC (sysdate-ACTUAL_START_D)

  2022-06-01 17:58:59 Views: 209
• 

  Quickly install zabbix using yum

  System environment: Centos 6.5.Software environment: Xshell 5. Install Zabix official source [root@localhost~] # rpm-ivh http://repo.zabbix.com/zabbix/3.

  2022-06-01 17:58:59 Views: 291
• 

  Deployment of Linux MYSQL database system and basic statements

  Deployment of Linux MYSQL database system and basic statements

  2022-06-01 17:58:59 Views: 201
• 

  RHEL 7.2 ORA-27300 ORA-27301 Database Crash

  First, environment description: operating system RHEL 7.2database ORACLE 12.2.0.1 production system II, official documentation solution APPLIES TO:Oracle Database-Enterprise Edition-

  2022-06-01 17:58:59 Views: 251
• 

  HBase to json

  Import com.alibaba.fastjson.JSON Configuration conf = HBaseConfiguration.create (); HTableInterfa

  2022-06-01 17:58:58 Views: 232
• 

  Detailed description of additions, deletions, alterations and searches

  two。 Modify table (emphasis) a) modify table name ALTER TABLE table name RENAME TO new table name b) modify field data type ALTER TABLE table name MODIFY field name data type attribute index; c) modify

  2022-06-01 17:58:58 Views: 218
• 

  Mongodump 、 mongorestore

  Generally speaking, mongoexport export is used for collection, while Mongodump can be a single table or an entire library. At the same time, the JSON output from mongoexport is more readable than Mongodump's BSON, and the JSON file

  2022-06-01 17:58:58 Views: 270
• 

  Methods for creating, using and deleting mysql views

  This article mainly gives you a brief introduction to the methods of creating, using and deleting mysql views. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on the creation, use and deletion of mysql views can give you

  2022-06-01 17:58:52 Views: 282
• 

  Registration code is required for expired Navicat-solution

  Problem description: the newly installed Navicat has expired in 30 days and requires a registration code solution: # Navicat for MySql V10.0.10NAVP-MKMP-MIJL-HIBFNAVP-UV3L-F7AI-6W4ANA

  2022-06-01 17:58:51 Views: 218
• 

  What is the cross connection of mysql

  This article mainly introduces what is the cross-connection of mysql, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand what is the cross-connection of mysql. # Cross connection: sql99

  2022-06-01 17:58:51 Views: 258
• 

  PlsqL review

  SELECT c.customer_id, COUNT (o.order_id) AS orders_ctFROM customers cJOIN orders oON for female customers who have placed orders for more than 4 times

  2022-06-01 17:58:50 Views: 301
• 

  MySQL datasheet field value is NULL how should it be handled

  I don't know if you have any knowledge about how to deal with similar MySQL datasheet field values of NULL. Today, I'm here to talk about it briefly. If you are interested, let's take a look at the body. I believe that after reading the MySQL datasheet, the field value is NULL. How should you be treated?

  2022-06-01 17:58:50 Views: 243
• 

  Percona Audit Log Plugin implements the operation steps of mysql audit

  Below to bring you about the Percona Audit Log Plugin implementation of the mysql audit procedures, I believe you must have read a similar article. What's the difference between what we bring to everyone? Let's take a look at the text. I'm sure after reading Perco.

  2022-06-01 17:58:50 Views: 253
• 

  MySql merges a field in a record

  One merges a field in a single record: concat () if for the user table, as follows: idclassnameage11001zh1821001en1931002cs1841002jp19 if you want to combine name and ag

  2022-06-01 17:58:50 Views: 286
• 

  Common Command Operation of mysql Database

  Let me tell you a little bit about the common command operations of mysql database. Have you known about similar topics before? If you are interested, let's take a look at this article. I believe it is more or less helpful to read the common command operations of the mysql database. Make good use of the help gang

  2022-06-01 17:58:46 Views: 215