MySQL DROP INDEX Summary: in this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table. MySQL DROP INDEX statement syntax To remove an existing index from a table, you use the DROP INDEX statement as follows: DROP INDEX index_name ON table_name [algorithm_option | lock_option]; Code…
Read more
MySQL CREATE INDEX Summary: in this tutorial, you will learn about the index and how to use the MySQL CREATE INDEX statement to add an index to a table. The phone book analogy Suppose you have a phone book that contains all the names and phone numbers of people in a city. Let’s say you want…
Read more
MySQL Index MySQL uses indexes to quickly find rows with specific column values. Without an index, MySQL must scan the whole table to locate the relevant rows. The larger table, the slower it searches. In this section, you will learn about MySQL index including creating indexes, removing indexes, listing all indexes of a table and…
Read more
MySQL Rename View Summary: in this tutorial, you will learn how to rename a view in MySQL using the RENAME TABLE statement or a sequence of DROP VIEW and CREATE VIEW statements. Introduction to the RENAME TABLE statement In MySQL, views and tables share the same namespace. Therefore, you can use the RENAME TABLE statement…
Read more
MySQL Show View Summary: in this tutorial, you will learn how to show all views in a MySQL database by using the SHOW FULL TABLE statement or by querying information from the data dictionary. MySQL Show View – using SHOW FULL TABLES statement MySQL treats the views as tables with the type ‘VIEW’. Therefore, to show…
Read more
MySQL DROP VIEW Summary: in this tutorial, you will learn how to use the MySQL DROP VIEW statement to delete a view from the database. Introduction to the MySQL DROP VIEW statement The DROP VIEW statement deletes a view completely from the database. Here’s the basic syntax of the DROP VIEW statement: DROP VIEW [IF…
Read more
Understanding LOCAL & CASCADED in WITH CHECK OPTION Clause Summary: in this tutorial, you will learn the differences between LOCAL and CASCADED in WITH CHECK OPTION clause. Note that you should be familiar with the WITH CHECK OPTION clause before going forward with this tutorial. If this is not the case, you can follow the…
Read more
MySQL Views & the WITH CHECK OPTION Clause Summary: in this tutorial, you will learn how to ensure consistency of the views using WITH CHECK OPTION clause. Introduction to MySQL View & the WITH CHECK OPTION clause Sometimes, you create a view to reveal the partial data of a table. However, a simple view is updatable…
Read more
Creating MySQL Updatable Views Summary: in this tutorial, we will show you how to create an updatable view and update data in the underlying table through the view. Introduction to MySQL updatable views In MySQL, views are not only query-able but also updatable. It means that you can use the INSERT or UPDATE statement to insert or update rows…
Read more
MySQL View Processing Algorithms Summary: in this tutorial, you will learn about MySQL view processing algorithms including MERGE, TEMPTABLE, and UNDEFINED. The CREATE VIEW and ALTER VIEW statements have an optional clause: ALGORITHM. The algorithm determines how MySQL process a view and can take one of three values MERGE, TEMPTABLE, and UNDEFINE. Here is the CREATE…
Read more