SQL Foundation One

Content: Database creation and deletion, table additions and deletions

Use library name , enter database operation

Create DATABASE name ,

drop database names , delete databases

-----------------------------------------------------------------------

CREATE table table name　 ,

（

whether the column name data type is empty set the primary key, ,, and the contents of the table

......

......

）

------------------------------------------------------------------------

DDL (data definition Language):

The task of executing the database, creating, deleting, modifying, and so on, the database and various objects in the database.

Create Create a database or database object/different database object with a different syntax form for the CREATE statement　　

alter modifies a database or database object to a different database object with a different syntax for the ALTER statement

Drop Delete a database or database object/Different database object whose drop statement has a different syntax

-------------------------------------------------------------------------------------

DDL (Data Manipulation language): used to manipulate various objects in the database, retrieve and modify data.

Retrieved:Select the column name to find, the column name to find from table name where condition order by

Insert:INSERT INTO table name (column name) VALUES (column value)

Modified: Updatetable name set column name = update value WHERE Condition

Delete: Delete fromtable name where to delete column name = column value to delete

--------------------------------------------------------------------------------------

Note: the end of each line to add,

SQL Foundation One