Category Archives: mysql

MySQL – Create Tables Table of content In the MySQL relational database system, SQL is used to store data in the form of structured tables. These tables consist of fields and records. A field represents a column that defines the type of data to be stored in a table, and a record is a row […]

MySQL – ALTER Command Table of content MySQL ALTER Command The MySQL ALTER command is used to modify the structure of an existing table. It allows you to make various changes, such as adding, deleting, or modify columns within the table. Additionally, the ALTER command is also used to add and drop different constraints associated […]

MySQL – Rename Tables Table of content There can be a situation where both users and database administrators might want to change the name of a table in a relational database to make the table”s name more suitable for a specific situation. MySQL provides two different ways to rename an MySQL table. We can use […]