Considerations for holding MySQL databases in PHP

Source: Internet
Author: User
1. the semicolon exception for MySQL, the first thing you must remember is that every line of its command is ended with a semicolon (;), ...... The same is true for a row of MySQL inserted in the PHP code.1. semicolon exceptions
For MySQL, the first thing you must remember is that every line of its command is ended with a semicolon (;), ...... The same is true for a row of MySQL inserted in PHP code. it is best to omit the semicolon (;). For example:
Mysql_query ('Insert INTO tablename (first_name, last_name)
VALUES ('$ first_name', '$ last_name ')
');
This is because PHP also ends with a semicolon as a line. The extra semicolon may sometimes make PHP syntax analyzer confused, so it is better to omit it. In this case, the semicolon is omitted, but PHP will help you add it when executing the MySQL command.

There is also a case where no extra points are required. When you want to display the vertical arrangement of fields, rather than horizontal arrangement as usual, you can use \ G to end a line of SQL statements, in this case, the semicolon is not used. for example:

SELECT * from penpals where USER_ID = 1 \ G

2. TEXT, DATE, and SET data types

A field in the MySQL data table must define a data type. There are about 25 options, most of which are directly clear, and there is little to worry about. But there are a few things to mention.
 
TEXT is not a data type, although it may be said in some books. It should actually be "long varchar" or "MEDIUMTEXT ".

The pattern of DATE data type is YYYY-MM-DD, for example. You can easily use the date function to obtain the current system time in this pattern:

Date ('Y-m-D ')

In addition, subtraction can be performed between DATA types to obtain the time difference days:

$ Age = ($ current_date-$ birthdate );

Clustering SET is a useful data type. it is similar to enumeration ENUM, except that SET can retain multiple values while ENUM can only keep one value. In addition, the SET type can have up to 64 predefined values, while the ENUM type can process up to 65,535 predefined values. What should we do if we need to have a cluster with more than 64 values? In this case, you need to define multiple aggregates to solve the title together.

3. wildcard characters

There are two types of SQL Wildcards: "*" and "% ". Resolution is used in different cases. For example, if you want to view all the content of the database, you can query it like this:

SELECT * FROM dbname WHERE USER_ID LIKE '% ';

Here, both wildcards are used. What do they mean in the same way ?? They are used to match any string, but they are used in different levels. "*" Is used to match the field name, while "%" is used to match the field value. Another concern is that the "%" wildcard must be used with the LIKE keyword.

Another wildcard is the underscore "_", which represents a different meaning from the above and is used to match any single character.

4. not null and empty records
 
What if the user presses the submit button without entering anything? If you really need a value, you can use a client script or a server script to perform data verification. However, in the database, some fields are allowed to be empty and nothing is required. For such records, MySQL will do something for them:

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.