UTF8 database, save emoticons, make an error
The code is as follows
Copy Code
Incorrect string value: ' \xf0\x9f\x98\x84\xf0\x9f ... ' for column ' content '
The wrong solution:
The code is as
Today in the processing of a movie site data, need to change part of the content, because this site has too many movies, a piece of processing is very difficult, so want to start from a part of the analysis, and then use to limit. At this time the
The function of this shell is to automatically restore MySQL master and slave error, is it feeling very powerful? All right, go straight to the code.
The code is as follows
Copy Code
#!/bin/sh# Check_mysql_slave StatusIp=
MySQL login and set password under Linux (this article is based on centos6.4, mysql5.7.3), MySQL installed in the/usr/local/mysql directory:
[Root@lnmp ~]#/usr/local/mysql/bin/mysqladmin-uroot password ' admin123 ' #修改mysql密码为admin123[Root@lnmp ~]#/
When you use PHP to insert large data into MySQL, you encounter a problem:
2006:mysql server has gone away:: INSERT into Hu Jintao
After looking, knowing the reason, is that MySQL's max_allowed_packet value is set too small or not set, this
Recently, encountered the MySQL master and slave library synchronization problem, mainly because the computer broke a bit of electricity, toss AH.Error from library log: Last_io_error:got fatal error 1236 from master, reading data from binary log: '
Centos 6.5 After installing MySQL 5.6.16, error using command logon:
[Root@test mysql-5.6.16]# mysql-u root-pEnter Password:Welcome to the MySQL Monitor. Commands End With; Or\g.Your MySQL Connection ID is 1Server Version:5.6.16-log Source
When a client using MySQL connects to a MySQL server, the following error occurs:
Error No. 1130Host ' 192.168.0.14 ' isn't allowed to connect to this MySQL server
Workaround:
1. Change Table method. Your account may not be allowed to log in
1, install PHP: will download the PHP compressed file decompression, folder renamed to PHP copied to the C-packing directory.
2, open just unzip the PHP directory, you will find a file called "Php.ini-dist", this is the PHP configuration file, you
Busy all day without results, suddenly remembered to look at the Appserv configuration file, sure enough passed. In the joy of ... Write it down first.
To use the software version:
Apache_2.2.6-win32-x86-openssl-0.9.8e.msi
Mysql-5.0.45-win32.exe
Php-
Long time no installed, the installation and found some problems, Gg,baidu searched a large circle, some solutions, some can not, my configuration method to write again, stay spare.
Goal: Win2003 Configuration Iis+php+zend+mysql+phpmyadmin
A list of
If I haven't written an article for a long time, do I want to write something? I will share my database design ideas, mainly aiming at the query optimization techniques for billions or more data on a single machine.If you only perform simple queries
Value typeThe numeric type is roughly divided into two categories: one is an integer, and the other is a floating point or decimal number.The integer type is commonly used as the int type and can be in the range of (-2147483648,2147483648.Float,
MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 Tips for adjusting and optimizing MySQL installation. Some tips are applicable to specific
Mysql queries are case-insensitive by default, for example:Select * from table_name where a like 'a % 'select * from table_name where A like 'A %'The results are the same.To make mysql queries case sensitive, you can: Select * from table_name where
MySQL master-slave replication is widely used in database backup, failover, data analysis, and other scenarios.MySQL master-slave replication tracks all database changes (updates, deletions, and so on) in binary logs based on the master server ).
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