If knowledge is power, then sharing knowledge is ultimate powertrip
Latest Updates
You are here: Home >> Tag Archives: Mysql

Tag Archives: Mysql

Feed Subscription

Difference between HAVING and WHERE Clause

havingwhere

The difference between having and where clause are given below. HAVING specifies a search condition for a group or an aggregate function used in SELECT statement. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. A HAVING clause is ... Read More »

Difference between distinct and group by in mysql

distinctAndGroupBy

The difference between DISTINCT and GROUP BY in Mysql is that they usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to remove duplicates then use DISTINCT. If you are using sub-queries execution plan for that ... Read More »

Full Text Search in MySQL

FullTextSearchMySQL

MySQL supports text searching by using the LIKE statement and regular expression. However, when the text column is large and the number of rows in a table is increased, using those methods has limitations: Performance: MySQL has to scan the whole table to find the exact text based on pattern in the LIKE statement or pattern in the regular expressions. Flexible search: with the LIKE statement and regular expression ... Read More »

Triggers in MySql

Triggers in mysql  is a set of Sql statements stored in the database catalog. A Sql trigger is executed or fired whenever an event associated with a table occurs e.g.,  insert, update or delete. Triggers in mysql is a special type of stored procedure. It is special because it is not called directly like a stored procedure. The main difference between a trigger and ... Read More »

Difference between InnoDB and MyISAM

Few difference between InnoDB and MyISAM are as: MYISAM: MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI) MYISAM not supports transaction. You cannot commit and rollback with ... Read More »

Query Caching in MySql

In some installations of MySQL, the query caching in MySql is disabled by default so you will have to do a little configuration to set things up. The way to check is to log into MySQL and issue the following command: mysql> show variables like ‘query%'; +——————————+———+ | Variable_name                | Value   | +——————————+———+ | query_alloc_block_size       | 8192    | | query_cache_limit            ... Read More »

Increase website performance

Hi All, The following are few points that I just wanted to share with you all. These points are the basic that should be kept in mind to increase website performance . HAPPY CODING Don’t use .htaccess Lock all ports down Stop ping Cut Apache modules down to bare minimum required for security Do not install all PHP modules Benchmark ... Read More »

Develop multilingual website in php

I’ve been working to develop multilingual website in php that grabs data from Hebrew news sites into a mySQL database. While working on this mini-project I’ve realized that there is hardly any online tutorials on using the Hebrew font. Here’s my solution which is fairly simple and works effectively. Step 1) Set the HTML page charset encoding to utf8: meta ... Read More »

Scroll To Top