MySQL Master master configurationMySQL dual master (Master) architecture scheme ideas1. Two MySQL can read and write, the main preparation, by default only one (Mstera) responsible for data writing, another (Masterb) standby2.masterA is the main
Install the MySQL plug-in of QT in windows. Refer to the two URLs.
Installation of http://www.jb51.net/article/23876.htm Database
Http://blog.csdn.net/polokang/article/details/6403303driver compilation process
Notes:
Change mysql. pro to a
1. Database code is UTF-8
2. The client code is GBK;
How to insert Chinese Characters
Example:
Create Database mydb;
Use mydb5;
Create Table news ( news_id int not null auto_increment, news_title varchar (100) not null,
Preface
This blog post was previously written and is not very professional in some places. Let's take a look at it. Of course, it is not a problem to install MySQL by following the steps.
Installation environment description:
System: Ubuntu
MySQL replace usage1. ReplaceReplace into table (ID, name) values ('1', 'A'), ('2', 'bb ')This statement inserts two records into the table. If the primary key ID is 1 or 2 does not existIt is equivalentInsert into table (ID, name) values ('1', 'A'),
MySQL Date and Time Functions (1)Author: mr. ZhangMySQL Date and Time StyleThere are many useful date and time functions in MySQL. We often see that a lot of calculations that are applied to date are in the codeBut they can actually use the built-in
1. Install apahce,PHP,MySQL,And PHP connection to MySQL library components.Yum-y install httpd PHP MySQL mysql-server PHP-MySQL
2. Configure the startup Service /Sbin/chkconfig httpd on[SettingsApacheServer httpd service startup] /Sbin/chkconfig --
I. string typeCharset (STR) // returns the string Character Set
Concat (string2 [,...]) // connection string
Instr (string, substring) // returns the position of the first occurrence of the substring in the string. If no position exists, 0 is
Fenng of DBA notes has published an article about choosing a more suitable hardware for MySQL. I picked it and commented on it based on my usage habits. in the following section, the red font is my words.
--------------------------------------------
Slave_ SQL _running: No MySQL synchronization fault solution today I checked the database and found that a MySQL slave was not synchronized with the host. Check the slave status:
Mysql> show slave status \ G
Slave_io_running: Yes
Slave_ SQL _running:
Using MySQL logs, You can redo some database operations:
D: \ mysql server 5.5 \ bin> mysqlbinlog "D: \ mysql server 5.5 \ data \ mysql-bin.000001"> D: \ test. SQL
Mysql-bin.000001 is a log file that is output to common SQL formats
/*!40019 SET
From: http://www.javaeye.com/topic/569864
The MySQL database is automatically disconnected after being idle for more than 8 hours, leading to the inability to connect to the website.
Developed an SSH-based websitePublish to serverGood dayThe next
Load data [low_priority] [local] infile 'file_name.txt '[Replace | ignore] into Table tbl_name[Fields[Terminated by '\ T'][Optionally] enclosed by ''][Escaped by '\'][Lines terminated by '\ n'][Ignore number lines][(Col_name,...)]
Load daThe TA
First, start and stop the MySQL Service
Net stop MySQL
Net start MySQL
Second, log on to MySQL
Syntax: mysql-u user name-P User Password
Enter the mysql-uroot-p command, press enter and prompt you to enter the password, enter 12345, and then press
[Reprint] URL: http://www.williswa.com/node/101
Remote login to MySQL on Ubuntu Solution
Mon,-williswatson
It took me a long time to do a good job. I wanted to remotely log on to MySQL on Ubuntu or Debian and set it in two places.
One is the MySQL
Problem descriptionAfter the Java Servlet submits the Chinese data to MySQL, It is garbled in the database,
SolutionStep 1: check data online and find that the encoding character set is incorrect. Set the encoding of the local database to gb2312.
When a primary key ID is deleted from the primary table, it cannot be deleted because the table associated with the primary key has related field data. I checked a lot of information and found that I used on restrict to create a table Association.
The Master/Slave node cannot be synchronized because the master disk is full. After the disk is added to the master node and the service is restored, the following error occurs:
Mysql> show slave status \ G;* *************************** 1. row ******
MySQLProvides standard SQL mode matching and a Unix-like utility suchVI,GrepAndSed.
SQL mode matching allows you to use"_"Match any single character, while"%"Matches any number of characters (including zero characters ). In MySQL, the SQL mode is
MySQL: www.mysql.org, MySQL service start and stop net stop MySQL Net start MySQL, MySQL login MySQL mysql-u user name-P User Password mysql-uroot-P, enter the password, enter 12345, and then press enter to enter mysql. The MySQL prompt is: mysql>
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service