To list all triggers in a MySQL database, you can use the SHOW command. The query is as follows −mysql> show triggers;The following is the output −+----------------+--------+----------------------+--------------------------------------------------------------------+--------+------------------------+--------------------------------------------+---------+----------------------+----------------------+--------------------+ | Trigger        | Event  | Table                | Statement           ... Read More

You can set primary key on an existing column in MySQL with the help of alter command.The syntax is as follows to add primary key to an existing column.ALTER TABLE yourTableName ADD PRIMARY KEY(yourColumnName);To set existing column as primary key, let us first create a table. The query to create ... Read More

To achieve this with LIKE operator, the following is the syntax −CREATE TABLE yourTableName2 LIKE yourTableName1;To understand the syntax, let us create a table and insert some records into it. The following is the query to create a table −mysql> create table Employee −> (    −> EmployeeId int   ... Read More

To add leading zero to some value, use the LPAD() function of MySQL. The syntax is as follows −select lpad(yourColumnName, lengthofColumnValue+1, 0) from yourTableName;Here is an example of LPAD().mysql> select lpad('98765432', 9, 0);The following is the output −+----------------------+ | lpad('98765432', 9, 0) | +----------------------+ | 098765432         ... Read More

To create a wobble animation effect with CSS, you can try to run the following code −ExampleLive Demo                    .animated {             background-image: url(/css/images/logo.png);             background-repeat: no-repeat;         ... Read More

In software development jargon, 'debugging' term is popularly used to process of locating and rectifying errors in a program. Python's standard library contains pdb module which is a set of utilities for debugging of Python programs.The debugging functionality is defined in a Pdb class. The module internally makes used of ... Read More

Sometimes while writing an iOS application or any other application we need to test multiple cases and debug the application of any known and unknown bugs. There are certain places in the code where we want our app to stop so that we can know the values of certain variables ... Read More

Detecting screen size of an apple device is an easy and simple task. The UIKIT module of iOS SDK provides many functions and classes that deal with user interface, screen sizes and many other UI elements.One of them is UIScreen which deals with the device screen.UIScreen.main provides the current main ... Read More

A url Scheme is a way of iOS to open some third party applications from within a app. Some of the URL schemes that are supported by facebook to open different modules of facebook app from within some other app are mentioned below.1. To open facebook profile: fb://profile 2. To ... Read More

The grayscale effect is used to convert the colors of the object to 256 shades of gray. The following parameter is used in this filter −ParameterDescriptionGrayConverts the colors of the object to 256 shades of gray.ExampleYou can try to run the following code to set grayscale effect −Live Demo   ... Read More