Categories
MySQL

MySQL Table Locking

Using MySQL Table Locking you can lock a table explicitly for preventing other sessions for a interval. Releasing a table lock can be granted for a client session only but not for other sessions. Here is a simple format for Table Locking: LOCK TABLE tbl [READ | WRITE] LOCK TABLE tbl READ To release a lock […]

Categories
Css

CSS Image Sprites

Image sprite is nothing but a collection of images put into a single image. When web page loads then for a particular location we show particular position of a image. For multiple images it takes time to load on a server. That is why we use single image for multiple position to save bandwidth. In […]

Categories
Html

Images in HTML

In html document, images are added via img element where the src attribute contains the url to the image path. Images example: <img src=”image.jpg”> There are different types of image format like jpg, png, gif, bmp etc.There is a attribute called “alt” which is used to give alternate information about the image or in case […]

Categories
Html

Meta Tags in HTML

This is meta information about your html document. It is not visible to the browser. For SEO purpose meta tags are used and written between head tags. Meta Tags: <head><meta name=”keywords” content=”Html, Web design, Meta tags”><meta name=”description” content=”This is html meta tags description”></head> Besides this lots of meta name are available.

Categories
Html

HTML Tricks for Non-Technical Person

Sometimes it is very tough for them who owned the website but can not modify any part of it. Rarely a non-technical person does it. You need a HTML Tricks. For any internet marketers, it should know as well as easily learn. You do not have to a web developer rather than a web researcher. […]

Categories
jQuery

Avoid jQuery conflicts with other libraries

jQuery uses $ as a alias or shortcut. So if you use another javascript library (like prototype, mootools etc) that uses same alias then you are in a jQuery conflicts situation. Use no-conflict mode to avoid jQuery conflicts: You have to use a new variable name to replace with jQuery $.For e.g. <script src=”jquery.js”></script> <script […]

Categories
MySQL

MySQL SELECT Statement

Using MySQL SELECT statement you can fetch combination of columns and rows from tables or views, known as a result set. This is the one of the most commonly used queries in MySQL to get data from the MySQL database. You can add or use one or more tables i.e. separated by comma for including various […]

Categories
MySQL

MySQL BETWEEN & Alias

To specify a range of test you can use BETWEEN operator. Example of BETWEEN: SELECT * FROM users WHERE age BETWEEN 18 AND 55; Here below 18 and above 55 aged user will be eliminated. For your own understand you can give an alias name to a column while getting the data from a table. […]

Categories
MySQL

MyISAM vs Innodb

MyISAM vs Innodb – both are commonly used engines on MySQL servers and they both have their unique advantages and disadvantages against each other. MyISAM is the default storage engine type for MySQL 5.0 but the Cloud Sites environment defaults the storage engine to Innodb. MyISAM vs Innodb: MyISAM: Table level locking.Innodb: Row level locking. […]

Categories
Html

HTML iframe

The iframe is used to include external html pages or other html pages inside another html page. iframe format: <iframe width=”400″ height=”300″ src=”http://example.com/”></iframe> There are different types of attributes i.e. width, height, name, src, srcdoc, seamless etc.