The method of querying a row of data in a table by mysql

This article shares with you the methods of querying a row of data in a mysql table. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How mysql queries a row of data in a table: use select statements to query, use where conditions, and select by row. The syntax is [select * from where].

How mysql queries a row of data in a table:

The basic syntax of the Select statement:

Select from where order by

If you want to query all data for a specified row in a table, the query statement can be written as follows:

Select * from where

Why this sentence? let's briefly analyze it. So the data actually includes all the rows and all the columns, so:

1. First select all the columns

The "collection of columns" should contain all the fields. You can use an asterisk (*) to refer to all fields in the SQL statement.

2. Then select the specified row

Select by row using the where condition.

Let's take a look at an example of querying all records in the test table whose tname value is name2:

Mysql > select * from test where tymename +-+-+ | t_id | t_name | t_password | t_birth | +- -+ | 2 | name2 | 12345678901234567890123456789012 | 2013-01-01 | +-- + 1 rows in set (0.00 sec) Thank you for reading! This is the end of the method of querying a row of data in the mysql query table. I hope the above content can be helpful to you so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.