Question

What is a Query?

Answer 1

A query is a request for data or information from a database table or combination of tables. A database query can be either a select query or an action query.

SELECT fname, lname /* select query */

FROM myDb.students

WHERE student_id = 1;

UPDATE myDB.students /* action query */

SET fname = 'Captain', lname = 'America'

WHERE student_id = 1;