MySQL – Unique Index Table of content MySQL Indexes are used to return the data from the database real quick. The users cannot see the indexes performing, instead they are just used to speed up the queries. However a unique index, in addition to speeding up data retrieval queries, is also used to maintain data […]
Category Archives: mysql
MySQL – Select Query Table of content Now that we have learned how to create tables in MySQL and insert values into it in the previous tutorials, the next step is to check whether the values are recorded in this table or not. To do this, one must use the SELECT statement to retrieve and […]
MySQL – Insert Query Table of content After creating a table in a MySQL database with the CREATE TABLE statement, we will only have an empty table that only has its structure defined. To populate it with data, we need to add records manually using separate queries. The MySQL INSERT Statement To insert data into […]