It's not much, it's just a code.
A query of numeric data:
SELECT * from Tb_name WHERE sum > 100;
Query predicate:>,=,,!=,!>,!,=
Two query strings
SELECT * from tb_stu WHERE sname = ' Xiao Liu '
select * from Tb_stu where
This paper illustrates the configuration method of MySQL database optimization technology. Share to everyone for your reference, specific as follows:
(i) Reduction of database access
For pages that can be static, try to be as static as possible
As shown in the following table:
Use the Str_to_date function first, convert its varchar type to date type, and then sort from small to large
Syntax: Select Str_to_date (class_time, '%y%m%d%h:%i:%s ') A from an order by a desc;
Next, let's
Copy Code code as follows:
INSERT table (auto_id, Auto_name) VALUES (1, ' yourname ') on DUPLICATE KEY UPDATE auto_name= ' yourname '
using on DUPLICATE KEY updateIf you specify on DUPLICATE key update and the insert row causes
Definition of a variableThe variable definition in MySQL uses declare to define a local variable, which can only be used in a begin...end block, and the variable must be defined at the beginning of the compound statement, and before other statements,
BLOB (Binary large object), binary large objects, is a container in which binary files can be stored. In the computer, a blob is often the type of field used in a database to store a binary file, a blob is a large file, a typical blob is a picture
A. 10 words
1. Do not rely on register_global=on environment, from you just know how to configure PHP to run the environment not even understand Register_global On/off will have any impact on their own day, you should be brave to set it off.
2. See
The following article is mainly about the performance of MySQL closely related to the five configuration parameters of the introduction, I saw a few days ago in the relevant web site on the performance of MySQL closely related to the five parameters
This article illustrates the MySQL implementation method that merges multiple data with the same ID. Share to everyone for your reference, specific as follows:
Such as:
CREATE TABLE ' c_classuser_tab ' (
' Id ' int () NOT NULL
When you install, reload when the could not start the service MySQL error:0reason: uninstall MySQL did not completely remove the related files and services, need to manually clear.
Workaround When you install to the last step when execute does not
Objective
MySQL provides a number of powerful, easy-to-use functions, using these functions, can greatly improve the user's management of the database efficiency, and thus more flexible to meet the needs of different users. This article classifies
--Basic query
SELECT * FROM Pet
--Lists the specified columns
Select name, owner form Pet
--Direct arithmetic operations, alias Fields
Select sin (1+2) as Sin
--where conditions
SELECT * FROM pet where (birth> ' 1980 ' and species= ' dog ')
This article for you to share two kinds of MySQL to create a database method for your reference, the specific content as follows
The first method: using Mysqladmin to create a database with ordinary users, you may need specific permissions to
1.1 Environment Construction
Prepare two Windows NT hosts, install the Ikey Server Windows version separately, make sure that the MySQL service starts properly, and make sure that the two hosts are on the same LAN. Determine which station is the
Quickly view the compilation parameters of the Server software:1, nginx compilation parameters:Your_nginx_dir/sbin/nginx-v2, Apache compilation parameters:Cat Your_apache_dir/build/config.nice3, PHP Compile parameters:Your_php_dir/bin/php-i |grep
This is Bbs.sql
CREATE TABLE Bbs_area (
ID Int (a) unsigned DEFAULT ' 0 ' not NULL auto_increment,
Master varchar not NULL,
Banner varchar () not NULL,
Body text is not NULL,
Email varchar (50),
Login varchar (20),
passwd varchar (20),
PRIMARY KEY (
Hello everyone! Long time no see everyone, the last time I wrote a file with PHP chat room operation, of course, is porous, and every time the screen is very bad! I think for a long time, is there a way not to refresh, you can get the message of the
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