MySQL Tutorial
Introduction Installation of MySQL Getting MySQL server information RDBMS Concepts Data Definition Language Data types Managing Databases Managing Tables Managing Views Inserting records in a table Updating records in a table Deleting records from a table Retrieving Records Data Control Language Variables in MySQL Procedures in MySQL Built-In functions in MySQL User Defined functions in MySQL Triggers in MySQL Cursors in MySQL Transaction control Event scheduler Tuning MySQL Server Performance Managing users Importing and Exporting data Database Testing Workbench PHPMyAdminDDL in MySQL
DDL stands for Data Definition language. DDL is used for defining database schemas. We can use DDL to perform below operations.- Create table
- Drop table
- Alter table
- Rename table
- Truncate table
- Enforce referential integrity
- Specify default values for the columns
- Specify if column values can have NULL values or not
- Specify if column values can have only unique values or not
- Specify data type for each column in a table
Here is the output of above example.
Web development and Automation testing
solutions delivered!!