MySQL Classic questions:
(ERROR 1366 (HY000): Incorrect string value: ' Xd5xd4 ' for column ' name ' at row 1)
There are a lot of online to solve Chinese garbled paste, roughly speaking is to modify%mysql_dir%/my.ini DEFAULT-CHARACTER-SET=GBK or
MySQL Spatial data type explanation
MySQL has a data type that corresponds to the OpenGIS class. Some types can only hold a single geometric value:
· GEOMETRY
· Point
· LINESTRING
· POLYGON
Geometry can save any type of geometric value. Other
Solaris has its own MySQL server, a lot of trouble. When used, only a small configuration can be done.
1. Login system with root user, enter/usr/sfw/bin/mysql_install_db in terminal
2. Create MySQL user and group:
# Groupadd MySQL
# useradd-g
1, install MySQL
This should be very simple, and I think everyone in the installation is not too much problem, so it is not much to say, the following we talk about configuration.
2. Configure MySQL
Note that under Ubuntu, MySQL defaults to only
There are two main reasons for MySQL downtime:
1. Memory is heavily occupied by other processes, or the database itself is too large to cause MySQL downtime2. Program access to MySQL did not perform mysql.close, a large number of resources caused
Q: How to solve the MySQL 5.0.16 garbled problem?
A: MySQL 5.0.16 garbled problem can be solved in the following way:
1. Set phpMyAdmin
Language:chinese Simplified (zh-utf-8)
MySQL Character Set: UTF-8 Unicode (UTF8)
MySQL Connection
Today, in writing the SQL statement, I want to make sure that MySQL is not equal to the operator is the symbol of what the
After testing found in MySQL with <> and!= is OK, but SQL Server does not recognize!=, so it is recommended to use <>Selece *
Optimization of SELECT * and select fields.
Let's start with a test, I have 260,000 records in my test database.
Check the number of columns again:
SELECT COUNT (*) from Information_schema.columns WHERE table_schema= "Lezhi_data ' and
See all the software that Ubuntu has installed:Dpkg-l Dpkg-l | grep MySQLView the path to the software installationDpkg-l | grep MySQLCheck the boot-up software to install additional plugins:sudo apt-get install rcconfrcconf a whole bit more: sudo
SELECT left (name,1) from a;//intercepts the first characterSelect POSITION ('. ') In name) The from a;//index is returned. In the position of the stringSelect Left (name,position ('. ') In name), from a;//intercept the number on the leftSELECT now (
MySQL CREATE database, data table, default setting is Latin1_swedish_ciSo when we create the database and data table should be based on their own needs to modify the format of the encoding, generally with UTF8_GENERAL_CIYou can also modify the MySQL
Function:1. Intercept string from leftLeft (str, length)Description: Left (truncated field, intercept length)Example: Select Left (content,200) as abstract from my_content_t2, starting from the right to intercept the stringRight (str,
I have encountered this error in Web engineering two times.For the first time, Mysql-connector-java-5.1.35-bin.jar did not import the project inside, but just the reference.In Java engineering, there is no problem if you refer directly to it, but
1.connector SQL Interactive language,php,java , etc.2. System Management and control tools3. connection pooling management buffering user connections, threading, etc. need for caching requirements4.SQL Interface accepts Sql commands and returns
MySQL query batch insert batch update optimization, mysql insert
Recently, when I was studying mysql, I encountered the problem that mysql batch insertion and batch update are not efficient. I have been using sqlserver for a long time. mysql is
Install mysql zip package version in win10 and win10mysql
Download zip https://www.mysql.com/downloads/ from official website
Extract
D: \ devtool \ mysql-5.7.17-winx64 \
Add D: \ devtool \ mysql-5.7.17-winx64 \ bin to Environment
Printf () and printfIf you want to output a mixed product composed of static text and dynamic information stored in one or more variables, the printf () Statement is no longer ideal. There are two reasons why it is ideal. First, it clearly divides
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