![]() Single-Line Comments: The single line comments start with ‘–‘.Like any other programming language, there are mainly two types of comments. Now, before I start with the commands, let me just tell you the way to mention the comments in MySQL. This section consists of those commands, by which you can define your database. So, let's get started now! MySQL Tutorial: Data Definition (DDL) Commands In this blog on MySQL Tutorial, I am going to consider the below database as an example, to show you how to write commands. We are going to cover each of these categories one by one. The TCL ( Transaction Control Language) consists of those commands which mainly deal with the transaction of the database.Īpart from the commands, following are the other topics covered in the blog:.The DCL (Data Control Language) commands deal with the rights, permissions and other controls of the database system.The DML (Data Manipulation Language) commands deal with the manipulation of data present in the database.Example: CREATE, DROP, ALTER, TRUNCATE, COMMENT, RENAME. The DDL (Data Manipulation Language) consists of those commands which are used to define the database.The topics covered in this article are mainly divided into 4 categories: DDL, DML, DC, and TCL. ![]() In this blog of MySQL, you will be learning all the operations and commands that you need to explore your databases. In the previous article, What is MySQL, I introduced you to all the basic terminologies that you needed to understand before you get started with this relational database. MySQL Tutorial is the second article in this blog series.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |