MySQL - SQL

Contents

A. INTRODUCTION

1. Introduction: Database

2. MySQL: Introduction

B. DATABASE

3. Create Database

4. Delete Database

5. Create Table

6. Delete  Table or Truncate Table

7. Alter Table

8. Constraints

• NOT NULL

• UNIQUE

• PRIMARY and FOREIGN KEY

• CHECK.

• DEFAULT

9. Index

C. SQL STATEMENTS

QUERY AND MODIFY TABLES

10. SELECT

11. DISTINCT

12. WHERE

13. ORDER BY

14. LIMIT

15. AND, OR, NOT

D. SQL Tips

16. Check Uniqueness of Column Records