Author: Namaste UI (Author)

To group rows into subgroup by one or more values of columns we use MySQL GROUP BY. Suppose in user table same country name exists for many times for different user. So if we use GROUP BY for country column to a SELECT query then only unique country will be listed. EXAMPLE: SELECT * FROM […]

Using CREATE TABLE statement in MySQL you can create a table into the database. The following example shows the statement in the simple form: CREATE TABLE Format: CREATE TABLE IF NOT EXISTS `tbl` ( tbl_id int(11) NOT NULL AUTO_INCREMENT, tbl_title varchar(100) DEFAULT NULL, post_date DATE DEFAULT NULL, update_date DATE DEFAULT NULL, PRIMARY KEY (tbl_id) ) […]

A segment of declarative SQL statements which is stored inside the database catalog is called stored procedures, invoked by a triggers. Advantages: When stored procedures are created it is compiled and stored in the database so that when it is called multiple times then the compiled version is used. It is very secure. It is […]

To store a temporary result set you can use a special type of table i.e. called MySQL temporary table. To keep temporary data, the temporary tables could be very useful in some cases. When the current client session terminates, the temporary tables is deleted. This is useful for stored procedures, join query etc. Temporary tables […]

Sometimes we need to add demo text in a website for checking whether it working fine or somewhere we test website with demo text. So on this case unwanted text inserted into database and you need to remove it. So, we can update fields with random sentence in this case. For example the fields value […]

Using IN operator in MySQL you can match the value from a set of values or a subquery. Example of MySQL IN: SELECT * FROM user WHERE country IN (‘IN’,’AUS’); Here both the user from IN and AUS will be shown in the result. You can also check for exception like: SELECT * FROM user […]