MySQL is more and more used in database applications because of its small size and efficient operation. I used to develop a peer-to-peer application of the use of MySQL to save Peer-to-peer nodes, due to peer-to-peer applications, knot points are
Two. VB Program of Guide Library
This project to use some object library, in the database access, decided to use ADO (ActiveX Data Objects), for the use of ASP, the name should be very familiar with, in fact, it in the application of VB is almost
There are two tables T_appinfo and g_appinfo, the stored information is basically consistent, all contain package_name this field, now need to find out package_name exists in the T_appinfo table, and does not exist in the G_appinfo table records.
1. Script statement
Before importing, CharSet GBK first.
To modify a table field encoding:
Note: The data inserted here is imported, and the console will complain. Executed in our client tools, there is no error.
2. In MyBatis, the XML file is
On the server command line login, Mysql-uroot-upassword, write the password to the command line, do not need to input each time, press ctrl+p and then enter, try N times, and finally logged in; The number of connections, after all, can still find a
To see if the log is open
1. Can be confirmed by MySQL profile my.cnf (MySQL defaults to open binary logging):# Replication Master Server (default)# Binary logging is required for replicationLog-bin=mysql-bin
Refresh Log
Flush logs;
View current
MySQL Modify field length
ALTER TABLE news Modify column title varchar (130);
ALTER TABLE name modify column field name type;
For example: the title field in the news table is 100 characters in length and is changed to 130 characters
ALTER TABLE
My server event log has a lot of changed limits:max_open_files:2048 max_connections:800 table_cache:619 warnings, which are issued by MySQL, which roughly means Max_ Connections and Table_cache do not match the generated, but for a moment I do not
Type of a value
Storage required for column typesTINYINT 1 bytesSMALLINT 2 bytesMediumint 3 bytesINT 4 bytesINTEGER 4 bytesBIGINT 8 bytesFLOAT (x) 4 if X FLOAT 4 bytesDOUBLE 8 bytesDOUBLE PRECISION 8 bytesReal 8 bytesDECIMAL (m,d) m bytes (d+2, if
The wrong hint is as follows
#/home/binbin.zhengbb/ssh/update_dns.sh
ERROR 1040 (08004): Too Many connections
ERROR 1040 (08004): Too Many connections
The reason for this error is that the amount of traffic is really high, the MySQL server will
1. Grant statement
Format: Grant Select on database. * To User name @ login host identified by "password"
Description
(1) Grant all grants all permissions
(2) All tables in the Demo.* database demo
(3) NewUser user name
(4) @localhost MySQL
MySQL installed on the FreeBSD host when the database files are placed under/var/db/mysql, the default storage location on the Linux host is/var/lib/mysql/.
If you want to replace the storage location of the MySQL data file:
FreeBSD under:
The benefits of using MySQL master-slave replication are:
1, the use of the master-slave server architecture, stability can be improved. If the primary server fails, we can use the server to provide services;2, in the master and slave server
For the first step, click the "Launch" button under your control Center
The second step, then see, directly click on the database above.
Third, start creating it. Click Create DATABASE.
Four, enter the relevant information.
MySQL sleep for too many optimization methodsThe solution is: Open include/pub_db_mysql.php about line 73rd, and put the following section of code:
Connecting to a databaseif ($pconnect = = -100) {$this->linkid = @mysql_connect ($this->dbhost,
First of all, I used Perl to save files in the DBM database with more than 50,000 records and 15 fields per record. Now want to use MySQL, to the record guide over. The first step, all the DBM records are imported into a text file, each field is
Check on the Internet most people are said to be the issue of permissions, the following we told two kinds of MySQL tutorial 1017 wrong solution, friends can refer to.
ERROR 1017 (HY000): Can ' t find file: (errno:13)
The reason is that the MySQL
MySQL Tutorial quick Database Tutorial Backup and automatic backup Bat processing method, the following is the bat batch method, followed by the common SQL data various backup commands.
@echo offEcho.echo MySQL Database backup
Echo ****************
Note: If you use non-root permissions, add sudo before the command;# Update and upgradeApt-get update & apt-get upgrade# Install NginxApt-get install nginx-y# Install MysqlApt-get install mysql-server-5.6-y# Installing HHVMApt-get install hhvm-y#
In CentOS 7, yum list mysql * is used. There is no MySQL version that can be installed. In CentOS 7, the default database is MariaDB. For MariaDB, it is a branch of MySQL, the acquisition of MySQL by Oracle has the risk of closing the source, so
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