Making a website rather than mobile view is easy but now a days you must have to build the view on mobile also. You need to know some CSS tricks. Here are some CSS tricks which will help you to maintain responsive design: Word wrap is necessary to forcefully break the text into new line […]
Page rank is an algorithm that is used by search engine to rank your website depending on importance of links. Various types of links are available on your website i.e. backlinks, internal links, external links, inbound links, no-follow links etc. Some tips to increase page rank: Making backlinks are easy when you are done with […]
MySQL has an alternative of IF statement i.e. MySQL CASE statement by which you can check conditional statement. Besides the IF statement in MySQL, this provides an alternative conditional statement i.e. called CASE. The MySQL CASE statement makes the programming code more readable and efficient. You can use the simple CASE statement to check the […]
If statement allows you to execute a set of SQL statements based on condition. If certain condition returns true then statement executes, otherwise not. Example: DELIMITER $$ CREATE PROCEDURE MyifCond() BEGIN DECLARE x INT; SET x = 1; SET y = 1; WHILE x <= 10 DO SET x = x + 1; IF x […]
All the stored procedure needs parameters to make more flexible. It has one of these three modes i.e. IN, OUT or INOUT. IN: Default mode i.e. calling program has to pass an argument to the stored procedures and value of IN parameter is changed inside of stored procedure even after stored procedure ends, the values […]
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 […]
SlidesJS is a jQuery responsive slideshow plug-in for version 1.7.1+ with various features like responsive, CSS3 transition. It has the following features: Responsive CSS3 transitions Touch effect Easy setup Options width (number) & height (number) start (number) navigation (object) pagination (object) play (object) effect (object) callback (function) Here is a simple example: <!doctype html> <head> […]
One of the important thing for achieving MySQL database performance is indexing that allows faster gathering of data to optimize MySQL database. Here is the list to Optimize MySQL database: Indexing in MySQL will create an internal register which is saved in by the MySQL service.For e.g.ALTER TABLE table_name ADD INDEX (column_name); There is another […]
MySQL provides an easy way to export table result set into a CSV file. Suppose we have a query like: SELECT name, email, age FROM users WHERE status = ‘Active’; So if we need to export this data into a csv file then using below query we can do: SELECT name, email, age FROM users […]
Based on patterns regular expression is a powerful tool which gives you a flexible way to identify strings like email, IP address, phone number etc. Use Regular Expression in Mysql: For example, you want to find a name which starts with character A, B and C. SELECT name FROM users WHERE name REGEXP ‘^(A|B|C)’; Must […]