MySQL Character Set and verification set
I. Character Set
1. MySQL's Character Set settings are flexible
You can set the default Character Set of the server;
Default Character Set of the database;
The default Character Set of the table;
Column
SQL Script for select data from ebs and make a csv file to FTP, ebscsv
Declare cursor cur_lcy_test is select rcta. customer_trx_id, rcta. trx_number, rcta. trx_date FROM ra_customer_trx_all rcta WHERE rcta. customer_trx_id = 11993; -- rec_lcy_test
Mongodb distributed cluster (2. Replica set) and mongodb cluster copyOverview
Replica set is a type of master-slave replication. It is a master-slave replication that comes with the Failover function. It solves the disadvantages of the master-slave
Oracle remove tablespace data file ora-00604 ora-01426, ora-00604ora-01426Zookeeper
Project Background: Database Management in the previous development environment is messy. When the tablespace is insufficient, only data files are added. After the
MySQL database master-slave synchronization, mysql database master-slave
1. PreparationsPrepare two machines and install a MySQL database respectively. For example
10.254.141.23 as the primary database10.254.166.60 as the slave Database
For MySQL
Install DB2 FIXPACK and db2fixpack1. Run the su-root command to switch to the root user permission.2. Run the following command on each instance:Su-iname. $ HOME/sqllib/db2profileDb2 force applications allDb2 terminateDb2stopDb2licd-end # run at
Redis document translation_key sets the expiration time, redis_key
Available since 1.0.0. Use the Start version 1.01
Time complexity: O (1) Time complexity O (1)
Source: http://blog.csdn.net/column/details/redisbanli.html
Set a timeout onkey.
Mongodb Study Notes 02 and mongodb Study NotesMongodb Study Notes 02-CURD operations
CURD indicates Create, Update, Read, and Delete operations.
Create a database Directly use the database name and create a collection to create a database.
Create
Redis sentinel cluster construction and Jedis test graphic tutorial [2], redisjedis
In Redis, the establishment of sentinel clusters and the Jedis test graphic tutorial [1] have already written the setup and testing of sentinel clusters in Redis.
RHEL5.8 if the ext3 file system is damaged, only the file system is not repaired (fsck,
RHEL5.8 if the ext3 file system is corrupted, it will only detect and not repair (fsck-n)
[root@lei1 ~]# df -ThFilesystem Type Size Used Avail Use%
Database transactions and Database Transaction ProcessingConcept of database transactionsAn operation between two consecutive successful COMMIT or ROLLBACK is called a transaction. In a transaction, data modifications are committed or withdrawn
A few questions about SQL and a few questions about SQL
When we get a question, we are not eager to answer the question. It will not be worth the candle, but to analyze the ideas, methods, and objectives, we also need to think about whether there
Encountered ORA-14047: alter table | index rename may not be combined with other operations error, altertablerename
Encountered ORA-14047: alter table | index rename may not be combined with other operations Error
[oracle@rhel63single ~]$ sqlplus lc0
Use the Hive regular parser RegexSerDe to analyze nginx logs and regexserdenginx
1. Environment:
Hadoop-2.6.0 & apache-hive-1.2.0-bin
2. Use Hive to analyze nginx logs. The website access logs are as follows:
Cat/home/hadoop/hivetestdata/nginx.txt
1
Oracle Learning (11): PLSQL programming, oracleplsqlWhat is the structure and composition of PL/SQL? • PL/SQL (Procedure Language/SQL) • PLSQL is an Oracle procedural extension of the SQL Language • It adds process processing statements (such as
Data cleansing Note: Generation of the primary key class ID field, note Field
Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to
Mysql uses profiling to analyze the causes of slow SQL statements.
CleverCode colleagues recently recommended a mysql SQL statement analysis tool profiling, and found that this tool is very good, it can accurately analyze the specific time spent on
MongoDB3.0.1 is deployed in multiple parts. There are not many domestic deployment documents (HE zhixiong )., Mongodb3.0.1 he zhixiong1) The parts include:1. There are at least three config servers: The data block-to-shard ing is stored to determine
Updates to join table queries and table updates
Background:
I wrote a blog about database join Table query, "read database -- (6) Connection". It mainly talks about the connection type and how to use the connection for multi-Table query. This blog
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.