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…