Skip to content

W3schools

Subscribe Youtube For Video Tutorials
  • Academics
    • Physics
    • Chemistry
    • Math
    • Biology
    • English
    • Hindi
  • Tutorials
    • Quartz scheduler
    • Log4j
    • JUnit
    • Java Mail
    • Java Generics
    • JAXB
    • Jsoup
    • JSON
    • XML Parser
    • Data structure
  • Java
    • Java
    • Collection framework
    • Java date time api
    • Java regex
    • Design patterns
  • Android
  • Servlet
    • JSP
  • Spring
    • Spring
    • Spring AOP
    • Spring DI
    • Spring MVC
    • Spring spel
    • Spring boot
    • Spring security
  • Hibernate
  • WS
    • Stories
  • Python
  • Web
    • Ajax
    • HTML
    • CSS
    • Javascript
    • jQuery
      • jQuery UI
    • PHP
    • TypeScript
    • ReactJS
    • Backbone.js
    • Bootstrap
      • Bootstrap 4
    • XML
      • XML DOM
      • XPath
      • XQuery
      • XSD
      • XSLT
  • Angular
    • AngularJS
    • Angular 7 Tutorial
    • Angular 8 Tutorial
  • DB
    • SQL
    • SQLite
    • MongoDB
    • MySQL
    • Oracle
    • PL/SQL
    • PostgreSQL
    • PouchDB
    • DBMS
  • C
  • More
    • Q&A
    • Quiz
    • Ant
    • CPP
    • JDBC
    • JPA
    • JSF
    • JAR
    • Maven
    • WAR
    • WordPress

SQL SELECT Database

by

In case multiple databases exist in the SQL schema we have to select the database before performing any operation. The USE statement is used to select any existing database in SQL schema.
Syntax:

USE databaseName;

Example:

USE w3schools_db;

 
Next Topic: SQL DROP Database with example.
Previous Topic: SQL SHOW Database List with example.

 

Categories SQL
SQL SHOW Database List
SQL DROP Database
SQL Tutorial
  • SQL Syntax
  • SQL data type
  • SQL operators
  • SQL CREATE Database
  • SQL SHOW Database List
  • SQL SELECT Database
  • SQL DROP Database
  • SQL CREATE Table
  • SQL ALTER Table
  • SQL COPY Table
  • SQL RENAME Table
  • SQL DROP Table
  • SQL DELETE from table
  • SQL TRUNCATE Table
  • SQL CONSTRAINTS
  • SQL PRIMARY KEY Constraint
  • SQL FOREIGN KEY
  • SQL NOT NULL Constraint
  • SQL UNIQUE Constraint
  • SQL INSERT statement
  • SQL INDEX Constraint
  • SQL UPDATE statement
  • SQL SELECT
  • SQL UNIQUE keyword
  • SQL DISTINCT keyword
  • SQL SELECT TOP
  • SQL SELECT IN Operator
  • SQL NOT IN Operator
  • SQL BETWEEN Operator
  • SQL NOT BETWEEN Operator
  • SQL ALIAS Statement
  • SQL WHERE Clause
  • SQL AND Clause
  • SQL OR Clause
  • SQL UNION Operator
  • SQL LIKE operator
  • SQL ORDER BY Clause
  • SQL GROUP BY clause
  • SQL HAVING clause
  • SQL JOIN clause
  • SQL INNER JOIN
  • SQL LEFT OUTER JOIN
  • SQL RIGHT OUTER JOIN
  • SQL FULL OUTER JOIN
  • SQL SELF JOIN
  • SQL CARTESIAN JOIN
  • SQL Functions
© 2024 W3schools • Built with GeneratePress