Useful tips for everyday
How do I change MyISAM to InnoDB in MySQL? Convert MyISAM to InnoDB with phpMyAdmin Simply run the ALTER command to convert it to InnoDB…
How does table index help faster retrieval? Indexing makes columns faster to query by creating pointers to where data is stored within a database. If…
How do I edit a procedure in MySQL? To modify an existing stored routine (procedure or function), double-click the node of the routine to modify,…
What is the availability group listener? An availability group listener is a virtual network name (VNN) that clients can connect to in order to access…
How do you alert in SQL? Right click SQL Server Agent and select Properties. Select Alert System in the left pane and do the following:…
What is meant by traffic analysis? Traffic analysis is the process of intercepting and examining messages in order to deduce information from patterns in communication,…
How do I give a user access to a read only table in Oracle? SQL>create user scott_read_only_user identified by readonly; SQL>grant create session to scott_read_only_user;…
What is a self referencing table? Self-referencing table is a table that is a parent and a dependent in the same referential constraint. in such…
How do you loop through a cursor in SQL Server? Declare two variables – one is ProductID which is integer type and the other is…
How do you map a many-to-many relationship? When you need to establish a many-to-many relationship between two or more tables, the simplest way is to…