First look at the classification of SQL statements supported by MySQL
1, database selection, creation, discard and change
Use
Create Database
Drap Database
ALTER DATABASE
2, data table and index creation, change and discard
CREATE table
drop
The most troublesome problems and solutions that occur during the installation of MySQL
After installation, startup is not successful, on the card, the program is not responding.
How to resolve:
Find the MySQL installation directory
#Path
Background information
A lot of duplicate data has been generated since the database was recently designed because it was poorly thought out. Now you need to delete these duplicate data, and the statement you use is the group by to complete. To
Database with MySQL (configuration process If you have a problem can restart Tomcat try it)
First, download software
. J2se
Http://java.sun.com/j2se/.4.2/download.html
2.Tomcat Server
http://tomcat.apache.org/download-4.cgi
3.mysql Server
Http://
1. Assuming there are already mysql-5.5.10.tar.gz and cmake-2.8.4.tar.gz two source files
(1) First install CMake (mysql5.5 later is compiled by CMake)
[root@ rhel5 Local] #tar-zxv-f cmake-2.8.4.tar.gz
[root@ rhel5 Local] #cd
Each installation is always a little different, this time try it this way, also recorded.
1, first need to download the RPM package:
Mirrored address:http://mysql.mirrors.pair.com/Downloads/
According to different versions of the download can be
MySQL stored procedures
14.1.1 Create a stored procedure
In MySQL, the basic form of creating a stored procedure is as follows:
CREATE PROCEDURE sp_name ([proc_parameter[,...]])[Characteristic ...] Routine_body
Where the Sp_name parameter is the
#1067-invalid default value for ' xxx '
This error occurs when you modify a field in the table. Display: The field name already has an error.
You have to delete the field and add it again.
UTF-8 import MySQL Chinese no displayToday, the local
Test environment: MySQL 5.0.45
"Note: You can view the database version in MySQL by mysql> SELECT version ();"
one, the connection MySQL.
Format: mysql-h host address-u user name-P user Password
1, connected to the MySQL on the computer.
First
If you are using the MySQL 5.0.xThe following content can be saved directly to replace the My.ini in MySQL, remember to modify the Basedir and datadir two columns of the path.
Copy Code code as follows:
[Client]
port=3306
[MySQL]
The database file is large, about 70G,
If you have a normal migration, you need to export the data in the original database and then import the data in the new database
After careful consideration, is MySQL's database file stored in the same format
First, preliminary preparationTo develop MySQL extensions, of course, you have to install MySQL firstDownload Mysql-essential-5.1.65-win32
The red option must be selected because the MySQL extension requires a header file and a MySQL dynamic
Kinds of data types
Shaping: can have decimal and hexadecimal representations
Fu: Floating-point numbers consist of a number plus a decimal point plus a number. Two number sequences cannot be empty at the same time.
String: A character or number
Download
A. I'm using the ZIP archive version, and WIN8 64-bit machines support this, so I suggest using this. And this is relatively simple and clean. The address is shown in the picture. Drag to the bottom, see clearly 64bit ZIP Archive, click
Searching the web for half a day, the easiest way is to create a database in the new database that is the same as the original name, and then copy the. frm file into the OK.
However, sometimes this is not the case, the query will appear so-and-so
In the DBMS centerline to create a database test,table bintest,data field data type can be tested with Longblob
Test file C:\\test.iso, you can find any one file to modify it, I am looking for an EXE program, modified for Test.iso just
Maximum test
I. Export Data external
1 MySQL connection + to output the query results to the file. Execute on the command line (Windows cmd command line, Mac Terminal)
-H: followed by the linked host (host)
-U: The following is the user name
-P:
Download mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz from official website
Create a MySQL user
[Root@master home]# useradd mysql
[root@master data]# echo ' mysql ' |passwd--stdin MySQL
Change the user's password for MySQL.
PASSWD: All
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