Sql_STUDY

Sql_STUDY

  • Sql, Database

      DATABASE _ CREATE Create a new database Write the correct SQL statement to create a new database called testDB. CREATE DATABASE testDB; Delete a database Write the correct SQL statement to delete a database named testDB. DROP DATABASE testDB; Create a new table Write the correct SQL statement to create a new table called…

  • Sql, Basic Grammar

     SQL Grammer _ BASIC SELECT – extracts data from a database UPDATE – updates data in a database DELETE – deletes data from a database INSERT INTO – inserts new data into a database CREATE DATABASE – creates a new database ALTER DATABASE – modifies a database CREATE TABLE – creates a new table ALTER TABLE – modifies a table DROP TABLE – deletes…