Differences between execute and query methods in ThinkPHP _ PHP Tutorial

The differences between execute and query methods in ThinkPHP are analyzed. When I was a beginner at ThinkPHP, many people did not understand the differences between the execute () and query () methods. This article analyzes the differences between the two. As we all know, when the execute () and query () methods in ThinkPHP can be used to learn ThinkPHP, many people do not understand the difference between the execute () and query () methods, this article analyzes the differences between the two.
As we all know, the execute () and query () methods in ThinkPHP can both directly input SQL statements in parameters. But the difference is that Execute () is usually used to execute SQL statements such as insert or update., And Query is commonly used to execute select statements..
The execute () method returns the number of affected recordsIf you execute the select statement of SQL, the returned results will be the total number of records of the table:

The code is as follows:

$ Model = M ("MyTable ");
$ Result = $ model-> execute ('update MyTable set name = aaa where id = 11'); // The total number of rows returned

The query () method returns a dataset.:

The code is as follows:

$ Model = M ("MyTable ");
$ Result = $ model-> query ('select * from mytable'); // returns array ()

The difference between lift () and query () methods is unknown. This article analyzes the difference between them. As we all know, the execute () and query () methods in ThinkPHP can all be...