mysql query output

MySQL is a widely used relational database management system that provides many powerful query functions. This article will introduce MySQL queries and demonstrate how to use various query statements to output data.

Part 1: SELECT statement

The SELECT statement is used to select data from one or more tables. Here is an example of a basic SELECT statement:

SELECT * FROM table_name;

This will return all data in table "table_name".

If you only need to select specific columns, you can use the following syntax:

SELECT column1, column2, ... FROM table_name;

Here is a practical example:

SELECT id, name, age FROM users;

This will return all the columns in the "users" table ID, name and age data.

Part 2: WHERE statement

The WHERE statement is used to filter the data selected from the table. Here is an example using a WHERE statement:

SELECT * FROM users WHERE age = 25;

This will return data for all users whose age is equal to 25 years old.

You can also add more filters using operators such as ">", "<", "=", "!", ">=", and "<=" :

SELECT * FROM users WHERE age > 25 AND gender = 'Male';

This will return data for all users who are older than 25 years old and whose gender is male.

Part 3: LIKE statement

The LIKE statement is used to fuzzy search for matching data. Here is an example using the LIKE statement:

SELECT * FROM users WHERE name LIKE '%Tom%';

This will return all usernames that contain the string "Tom".

You can also use the following operators:

• "%" is used to match any sequence of characters (including 0 characters).
• "_" is used to match any single character.

Example:

SELECT * FROM users WHERE name LIKE 'Tom%';

This will return all usernames starting with "Tom".

Part 4: ORDER BY statement

The ORDER BY statement is used to sort the result set by the specified column. Here is an example using the ORDER BY statement:

SELECT * FROM users ORDER BY age DESC;

This will return user data in order from high to low age.

You can also sort by multiple columns at the same time:

SELECT * FROM users ORDER BY age DESC, name ASC;

This will return user data in order from highest to lowest age and A to Z by name.

Part 5: LIMIT statement

The LIMIT statement is used to limit the number of rows returned in the result set. Here is an example using the LIMIT statement:

SELECT * FROM users LIMIT 10;

This will return the first 10 rows of user data.

You can also specify the starting row and number of rows in the result set to be returned:

SELECT * FROM users LIMIT 50, 10;

This will return user data from row 51 to row 60.

Part 6: GROUP BY statement

The GROUP BY statement is used to group the result set by specified columns. Here is an example using a GROUP BY statement:

SELECT gender, COUNT(*) FROM users GROUP BY gender;

This will group by gender and return the number of users for each gender.

You can also use the HAVING clause to filter the grouped data:

SELECT gender, COUNT(*) FROM users GROUP BY gender HAVING COUNT(*) > 100;

This will group by gender and return gender data for users with a number greater than 100.

Summary

This article introduces many common syntaxes in MySQL queries, including SELECT, WHERE, LIKE, ORDER BY, LIMIT and GROUP BY. These syntaxes can be used for a variety of data filtering and sorting operations. Master these syntaxes to efficiently query and output your data.

The above is the detailed content of mysql query output. For more information, please follow other related articles on the PHP Chinese website!