Chapter4 Working with Database Structures

• Creating and Using Databases

• Creating Tables

1. Basics

2.Collation and Character Sets

• Other Features

  

• String types

 

 

 

• Keys and Indexes

 

 

• The AUTO_INCREMENT Feature

• Altering Structures

1. Adding,Removing,and Changing Columns

 

 

 

1. Adding,Removing,and Changing Indexes

 

1. Renaming Tables and Altering Other Structures

 

• Deleting Structures

     1. Dropping Databases

2.Removing Tables

​​​​​