Python零基础进阶：数据库操作与数据类型详解.pdfVIP

DataDefinitionLanguage

•Database

•Create Database

•Drop Database

•Alter Database

•Table

•Create Table

•Alter Table

•Drop Table

•Create Index

•Create View

Createtab

Droptab

Altertab

Used to

Add/drop/rename columns

Add/drop/rename indexes

Add/drop keys

Add/drop constraints

Change data type

DataManipulationLanguage

•Insert Into

•Update

•Delete

•Select

DataType

AddRecords–INSERTINTO

Product_idCodeNameClassColor