In this article we will first know what columns, rows and tables are in MySQL and then we will know how to manage columns in MySQL i.e. add columns, modify columns, remove columns or show columns. What are columns, rows, and table in MySQL? Columns in a table are the fields that store values for … Read more
Foreign Key A foreign key is a column or a combination of multiple columns of one table (we can call it a child table) that has a reference to the primary key of another table (we can call it a parent table). I have discussed about primary key and other indexes in my previous article … Read more
In this article, we will discuss in detail about indexing in MySQL. What is Indexing? In order to fetch data with specific column values from the database quickly, indexes are used. To easily understand what index is, we can take the example of any textbook. At the very end of the textbook, there is an … Read more