Free space without advertising PHP mysql ASP access space
Free unlimited host features: Support php5+mysql5/asp+access;10g large space for most sites is equivalent to No limit, unlimited flow, space and database configuration comparable to the
Network Space kostenlos!richtig! World Investment Report Gebendill Kostenlos North Dakota Free Werbefreien network space dedicated to wish your homepage!
UNBEGRENZT Speicherplatz North Dakota Branch-werbefrei North Dakota Free!PHP 5, MySQL in North
Free 100m/2.5g/php/mysql/ftp/cp/domain Space
100MB disk space-50MB MySQL Space-200MB Data backup space-100KB/S Exclusive Bandwidth-2.5GB flow per month-Supports PHP4, PHP5, HTML-Independent cpanel X11, Vista style host Control Panel-Perfect Support
Error
ERROR 1418 (HY000): This function has none of the deterministic, NO SQL, or reads SQL DATA in its declaration and binary Loggi NG is enabled (for your *might* want to use the less safe log_bin_trust_function_creators variable)ERROR 1418 (HY000
SELECT query Statements and conditional statementsInsert Insertion StatementUpdate UPDATES statement (Modify statement)Delete Deletion statement
Writing standard: All SQL operation statements are written in uppercase letters, others are lowercase.
The correct statement to change the table character set is:ALTER TABLE XXX convert to character set UTF8;Rather than take for granted:ALTER TABLE XXX default CharSet UTF8;
The character set is converted from GBK to UTF8,Increases the space occupied
Linux use service mysql restart command to restart MySQL service
The new database will use this character set as the default character set
Modify the character set of each database in the MySQL server
If there is a database before setting the
1. Export the entire database (–hex-blob for BLOB data, prevent garbled and import failures)
Mysqldump-u user name-p database name > exported file name
The code is as follows
Copy Code
Mysqldump-u
into Mysql:show full processlist;
Command more sleep, the client over the connection is also normal, repeated execution of the above command to find the state of some command "coping to TMP table", decisively open my.cnf found no tmp_table_size
MySQL query caching mechanism principle Querycache,querycache is based on SQL statements to cache. If a SQL query starts with SELECT, the MySQL server tries to use QC for it. Each cache is saved as a key with SQL text. SQL text will not be processed
Linux version: Ubuntu 12.04The PHP MySQL and Apache configuration was completed todayis mainly the source code configuration,Apache is mainly version 2.4.2PHP is mainly 5.3.11 versionMySQL is mainly 5.1.62 version
Several days ago tried several
Several password recovery methods commonly used in MySQL tutorials/*One of the methods of restoring MySQL passwordIf you forget the MySQL root password, you can reset it in the following ways:1. Kill off the MySQL process in the system;
MySQL tutorial Creating stored Procedures"Pr_add" is a simple MySQL stored procedure that has two input parameters of type int, "A", "B", and returns the and of the two parameters.
drop procedure if exists pr_add;
--Calculate the sum of two
Backup restore or data import error 1153:got a packet bigger than ' Max_allowed_packet ' bytes problemThere are 2 ways to solve this problem:1. Temporary modification:mysql>set global max_allowed_packet=524288000; #修改 512M2. Modify MY.CNF (under
Mysql Regular Expression queries records that contain non-numbers and characters, mysql Regular Expression
For example, we have a school table with the county_name field. Now we want to query records whose county_name field contains characters other
Mysql fuzzy query like and REGEXP Usage Details, fuzzy query regexp
Preface
In mysql, like and regexp are implemented for Fuzzy queries. This article describes how to use these two methods in detail through the instance code. Let's learn from them
GarbledWe recommend that you take a closer look at MySQL character set settings to distinguish between client and server encoding. The simplest and most violent method is to explicitly specify the same encoding in all links.For example, when using
Some chat versions of emoji are commonly used in office-based communication software, and it is found that they cannot be stored in mysql.Because the four bytes (\ xF0 \ x9F \ x90 \ xAC) of the emoji during storage );Because the database uses the
Old Jiang installed the MySQL database by default when installing the website environment on the Linux MB small memory VPS server the day before yesterday. It was found that the installation was not possible because the memory was insufficient
Then let's see what it looks like by default.Let's see what it looks like after using the prompt parameter.Then let's look at how black technology works.Now let's talk about the last color display method. By default, after the -- prompt parameter is
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