Summary
As a small relational database, MySQL has won the favor of a large number of small and medium-sized enterprises and individual users with the features of low price, powerful function, decent speed and open source. But in. NET access to the
1, if the MySQL server is the machine you want to export files, then you can directly use the Select ... into outfile statement.
SELECT * from rank to outfile "/home/a.txt"
2, if the MySQL server is a separate machine, we are operating on a client,
Indexes can improve the retrieval efficiency of the data, reduce the IO cost of the database, and the index can reduce the sorting cost of the database. Sorting grouping operations mainly consumes CPU resources and memory, so the ability to make
How to restore MySQL password
If you forget your MySQL root password, you can recover it through the following procedure.
1. Send Kill command to MYSQLD server to turn off MYSQLD server (not kill-9), and the file that holds the process ID is usually
The importance of Web site backup, believe that every webmaster is know, and now most stationmaster, have used the VPS host, in the Linux operating system, the VPS data backup main is, the website file, the database, the domain name configuration
PHP tutorials and MySQL tutorial performance tuning notes
The larger the tmp_table_size=200m tmp_table_size, the smaller the probability of being converted to a disk TMP table
PHP Program page MySQL closed in time
Set the MySQL timeout
MySQL tutorial. ini CPU High optimization method
The greater the tmp_table_size=200m tmp_table_size, the greater the probability of being converted to disk TMP table
Small
PHP Tutorial Program page MySQL closed in time
Set the MySQL timeout time
Using JDBC to connect to the MySQL Tutorial database tutorial, the JDBC driver has been added to the project "build path" of Eclips tutorial E, which is supposed to be normal. Prompts "Unable to load driver" after running the project.
The final
MySQL Tutorial clear table truncate and delete differences
This article demonstrates how to use the truncate command, and the difference between delete and truncateHere's a list of all the data instances that are deleted from a MySQL table.
MySQL tutorial concat () connection string detailed descriptionIn some cases you want two or more strings, in MySQL there is a string concatenation function concat (), let's talk about how it is used.
Concat syntaxConcat (STR1,STR2,...)
Simple
MySQL Tutorial modify table/Field Add/Remove Table index
CREATE TABLE Test (Blob_col blob, index (Blob_col (10)); in MySQL 5.1, for MyISAM and InnoDB tables, the prefix can be up to 1000 bytes long. Note that the prefix limit should be measured in
MySQL Tutorial database Tutorial Connection Classes/*Provide a simple and practical MySQL PHP Tutorial database connection Code Oh, if you are a PHP starter can come in and see if this database code is what you are looking for.*/
Class mysql{
LNMP installation of a key install the MySQL default is to open the log file, if the data operation is more frequent will produce a lot of log, under/usr/local/mysql/var/produce mysql-bin.0000* similar files, And generally in dozens of MB to several
The MariaDB database management system is a branch of MySQL and is mainly maintained by the open-source community. The purpose of using GPL to authorize MariaDB is to be fully compatible with MySQL, including APIs and command lines, it can easily
The code is as follows:Copy code DELIMITER $Create definer = 'root' @ 'localhost' FUNCTION 'uf _ get_tmaxcode '(V_iType INT) RETURNS varchar (10) CHARSET utf8BEGIN/*Business Description: code is generated based on the encoding category.Input
When you use DBI to insert Chinese characters into MySQL, the text in the database will show garbled characters (even if the table is encoded as utf8). You need to add encoding settings before reading the statement before inserting the statement.Let'
When there is more and more data in the database, how important is data backup. Next we will use shell scripts + crontab scheduled tasks to back up MySQL data (supporting multiple databases ), I will not explain the usage of shell and crontab too
$ Localhost = 'localhost'; // connect to the server. In most cases, use localhost,$ User = 'root'; // mysql logon account$ Upwd = '000000'; // logon password of the mysql server$ Db = 'DB'; // your mysql database The code is as follows:Copy code
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