I wanted to write some days ago, but I was so busy installing new server, that I could write it down when I was done. Now the new server also shelves, have time to slowly write several articles out of the,* ^_^ *
This is a fool-like tutorial, the
1, the installation of MySQL diagram.
2, the difference between different databases on the impact of the program
1) Data type
2) Paging problem
SQL paging is fairly simple, and the paging is different for different databases. SQL Server is also
This example all involved the file download address http://pan.baidu.com/share/link?shareid=1325829979&uk=2065228996
Step one: Build a database
Suppose you have a SQL file
Mysql>use dbname; Create a database with a database named dbname (empty
The following error was reported when deleting data from a table in MySQL:
mysql> delete from upload_images; ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column mysql> show
If we create a testindex table:
CREATE TABLE Testindex (i_testid INT not null,vc_name VARCHAR () not NULL);
We randomly inserted 1000 records into it, one of which
I_testid Vc_name
555 Erquan
Looking for records for vc_name= "Erquan"
SELECT *
I have been using the MySQL database software, it works more stable, efficient and very high. In the face of serious performance problems, there are generally several possibilities:
1, the index is not well established;
2, the SQL writing is too
I. Data definition DDL (data definition Language)
Data-setting language refers to the language defined in the format and form of data, he is the first to be set up when each database is to be established, what is the form of data, the form of a
1. Export the entire database
Mysqldump-u user name-p database name > exported file name
Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql
2. Export a table
Mysqldump-u user name-P database name Table name > exported file name
Mysqldump-u wcnc-p
Descending indexing and loose index scan
Descending indexing and mitigating index scans
Comments to I previous posts, especially this one by Gokhan inspired me to write a bit about descending indexes and about Loose index Scan, or what Gokhan
The basic syntax for a SELECT statement in MySQL is:
以下是引用片段: SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY] [DISTINCT|DISTINCTROW|ALL] select_list [INTO {OUTFILE|DUMPFILE} 'file_name' export_options] [FROM
An example of an error occurred:
Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (gbk_bin,IMPLICIT) for operation '=', SQL State: HY000, Error Code: 1267
Reason:
The encoding of the database is different from the coding of the table;
This paper discusses the way to improve the performance of MySQL database, and gives the concrete solution from 8 aspects.
1, select the most applicable field properties
MySQL can support a large amount of data access, but generally speaking, the
Indexing is the most important tool for improving query speed. Of course there are other technologies available, but generally the most significant performance difference is the correct use of the index. In the MySQL mailing list, people often ask
FAQ Gallery
MySQL always crashes
First you should try to figure out whether the mysqld daemon is dead or if your problem is related to your customer. You can use Mysqladmin version to check how long your mysqld server is performing properly, and
This article uses personal experience to solve SQL Mail configuration and use.
The main thing to do with SQL Mail is to do this:
> Users registered online, the system will randomly generated passwords sent to the user's registered email.
> users
Many server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behavior. However, most people are not aware that standard
The operating environment and resources used by this routine:
1. Tomcat 5.5
2. Mysql 4.1
3. mysql JDBC driver: 3.1.13
(The above procedures can be downloaded directly to the relevant official website)
Step1: First create a listener servlet,
A string or series (string) is a finite sequence of 0 or more characters. Generally recorded as s= ' a1a2 an ' (n>=0). It is the data type that represents text in the programming language.
A string is usually used as an action object, such as
As a system operation and maintenance engineer, normal view analysis Linux system log I think we must do the homework every day, but a long time will find that every time we look at the site logs have to go into the background, several servers can
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