How does MySQL query table records
This article mainly introduces "how to query table records in MySQL". In daily operation, I believe many people have doubts about how to query table records in MySQL. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to query table records in MySQL". Next, please follow the editor to study!
Query all the information that emp_name is Xiaotian in the emp table
MySQL (the best combination with PHP) > select * from emp where emp_name= Xiaotian
The query results are shown as follows:
+-+ | emp_id | emp_name | emp_age | emp_sal | emp_bir | emp_sex | +-+ -+ | 100005 | Xiaotian | 27 | 4000 | 1979-07-10 | male | +-+-+ 1 row in set (1979 sec)
Query all the information in emp table, emp_sal, salary above 5000
MySQL (the best combination with PHP) > select * from emp where emp_sal > 5000
The query results of the record query of the MySQL advanced query method are shown as follows:
+-+ | emp_id | emp_name | emp_age | emp_sal | emp_bir | emp_sex | +-+ -+ | 100001 | Red Maple | 29 | 9000 | 1977-01-01 | male | 100002 | rhododendron | 27 | 8000 | 1979-12-31 | fmale | +- -+-+ 2 rows in set (0.00 sec)
Query the emp table for those born after January 1, 1978
MySQL (the best combination with PHP) > select * from emp where emp_bir > 1978-01-01
The query results are shown as follows:
+-+ | emp_id | emp_name | emp_age | emp_sal | emp_bir | emp_sex | +-+ -+ | 100005 | Xiaotian | 27 | 4000 | 1979-07-10 | male | | 100002 | rhododendron | 27 | 8000 | 1979-12-31 | fmale | +- -+-+ 2 rows in set (0.00 sec)
Query the emp table of those born before December 1, 1979 with a salary of more than 5000
MySQL (the best combination with PHP) > select * from emp where emp_bir5000
The query results are shown as follows:
+-+ | emp_id | emp_name | emp_age | emp_sal | emp_bir | emp_sex | +-+ -+ | 100001 | Red Maple | 29 | 9000 | 1977-01-01 | male | +-+-+ 1 row in set (1977 sec) so far The study on "how to query table records in MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
