Community Learn Tools Library Leisure

English

Home > Database > Mysql Tutorial > In a query, which clause among 'SELECT', 'WHERE', and 'FROM' does the database server evaluate last, and why?

In a query, which clause among 'SELECT', 'WHERE', and 'FROM' does the database server evaluate last, and why?

王林

Release： 2023-08-31 09:05:02

forward

1165 people have browsed it

In a query, which clause among SELECT, WHERE, and FROM does the database server evaluate last, and why?

As we all know, the SELECT clause is used to display all rows and columns, so the database server evaluates the SELECT clause last.

The above is the detailed content of In a query, which clause among 'SELECT', 'WHERE', and 'FROM' does the database server evaluate last, and why?. For more information, please follow other related articles on the PHP Chinese website!

source：tutorialspoint.com

Previous article：How do MySQL stored GENERATED COLUMNS work with built-in functions? Next article：How to migrate MySQL to MariaDB on Linux?

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Latest Articles by Author