1, select the most applicable field properties
MySQL can support a large amount of data access, but generally speaking, the smaller the table in the database, the faster the query executed on it. Therefore, in order to achieve better performance
From http://www.devshed.com/c/a/MySQL/Error-Handling-Examples/
Error Handler Examples
Here are some examples of handler declarations:
If any error condition arises (other than a not FOUND), continue execution after setting L_error=1:
DECLARE
Copy code code as follows:
DELIMITER $$
CREATE
FUNCTION ' T_girl '. ' Func_rand_string ' (f_num tinyint unsigned, f_type tinyint)
RETURNS varchar (32)
BEGIN
--Translate the number to letter.
--No 1 stands for string.
--
First, environmental installation1. Install Apache2sudo apt-get install apache2Open in Browser after installation: http://localhost/or http://127.0.0.1If the IT works! proves the Apache installation is successful.2. Install PHPsudo apt-get install
Grammar:
Group_concat ([DISTINCT] expr [, expr ...] [ORDER BY {Unsigned_integer | col_name | expr}[asc | DESC] [, col_name ...]] [SEPARATOR Str_val])
Here is a demonstration of this function, first set up a student to choose the timetable
Collect the Compare full MySQL date and MySQL time function
Date_format (Date,format)
Formats the date value based on the format string. The following modifiers can be used in the format string:%m month name (January ...). December)
%w Week name
This article illustrates the way PHP operates MySQL. Share to everyone for your reference, specific as follows:
Set all UTF-8 encoding for Zend Software
Set the encoding for a single project UTF-8
demo1.php
config.php
MySQL supports a large number of column types, which can be grouped into 3 categories: numeric types, date and time types, and string (character) types. This section first gives an overview of the available types, summarizes the storage requirements
Just cut to the chase:
Generally speaking, the slow query we see is not likely to cause the hang station, at most the application response slows downBut this happened to me today, a slow query to get the whole site hung uplook at this SQL sheet
MySQL supports one-way, asynchronous replication, in which one server acts as the primary server and one or more other servers act as the server . The master server writes the update to the binary log file and maintains an index of the log file to
Introduced
Have not been too careful about the MySQL password security policy configuration method, but the artificial password is set to a complex password, but did not find the method of configuration, today Kang's micro-letter public number just
Just follow the 3 steps below, and everything is under your control:
First step: Configure the backup directory code on the server:
--------------------------------------------------------------------------------
Mkdir/var/lib/mysqlbackup
Cd/var/lib/
1303-can ' t create a PROCEDURE from within another stored routine.
This error message is more difficult to understand, so carefully check the contents of the stored procedure, there is no problem, the code is as follows:
Copy Code code as
This article describes the PHP implementation of the MySQL duplicate ID two-dimensional array into a three-dimensional array of methods. Share to everyone for your reference, specific as follows:
Application Scenarios
MySQL when using associated
This example describes a workaround for the Union clause in MySQL that does not support order by. Share to everyone for your reference, specific as follows:
I know very little about db, this problem is only encountered in MySQL, I do not know other
This article describes the Java data type and MySQL data type comparison table. Share to everyone for your reference, specific as follows:
Type name
Display length
Database type
Java type
JDBC Type index (int)
Working Environment Windows Server 2003, MySQL installation directory D:\MySQL, WinRAR installation directory C:\Program Files\winrar\winrar.exe
The path to the backup data store is the E:\ data backup, so let's start with the DOS batch command.
First, MySQL5.7.13 installationto MySQL official online http://dev.mysql.com/downloads/mysql/, download MySQL can install the DMG versionmysql-5.7.13-osx10.11-x86_64. DMGThe downloaded files are: mysql-5.7.13-osx10.11-x86_64. dmgClick on the
For the previous installation of MySQL notes are summarized, to share with you.
1. Download
Download Address: http://dev.mysql.com/downloads/mysql/
According to the computer configuration to choose, I chose Windows (x86,64-bit), ZIP Archive This,
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