In MySQL, columns and rows make up the tables. The rows and columns of data records define the fields and…