What is the use of use keyword in SQL?

Question

The USE keyword is used to select a database in MySQL and SQL Server.

What does use do in MySQL?

The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The database name must be specified on a single line.

What is the use of as keyword?

SQL AS keyword is used to give an alias to table or column names in the queries. In this way, we can increase the readability and understandability of the query and column headings in the result set.

What is keyword in SQL with example?

In SQL, the keywords are the reserved words that are used to perform various operations in the database. There are many keywords in SQL and as SQL is case insensitive, it does not matter if we use for example SELECT or select.

Expert · Answer