There are a lot of SQL statements such as DDL, DML, DCL, TC, etc.Įxamples of Data Definition Language statements (DDL) are create, rename, alter, truncate, comment and drop. However, these tools must also use SQL when querying the database. Examples are the likes of PHPMyAdmin, MySQL workbench, etc. There are other applications / tools that can be used to access MySQL database without using SQL directly. In RDMS, you use a structured query language (SQL) to access the database. To learn more about relational database management system (RDMS), click on this link You may want to store information about all your employees, you will have to create a table and the table will have fields as well. Hence why in RDMS, data is stored in tables & rows and has fields. The relational representation consists of a set of operators and object relations. Codd in 1970 who proposed relational model for database systems. The basis of the relational database management system (RDBMS) was from Dr.
0 Comments
Leave a Reply. |