PHP Freelancer PHP Freelancer India PHP Programmer India PHP Freelancer Indian Freelancer Freelance Programmer Freelance Developer Freelance Web Developer Freelance Programmer India Hire PHP Developer India Wordpress Developer India CakePHP Developer India
MYSQL
Clustered indexes Vs Non-clustered indexes
A clustered index is a special type of index that reorders the records in the table are physically stored. In non-technical way, you are telling the database to store close values to one another on the disk. This means, a table can have only one clustered index. This has the benefit of rapid scan / retrieval of records on any operation with clustered index values.
Difference Between Primary Key and Unique Key
Everybody knows about difference between Primary key and Unique key who is/was working with SQL. This is silly question but still in lots of interview, interviewer asking this question starting from Fresher post to Experience post. This is a basic question and you must be aware with all the differences. You may know the difference but may be not know all.
Multiple MYSQL Database Connection in PHP
Do you want to make a MYSQL connection with multiple database in PHP? I am working on project where i need to use two database. I prefer not to make separate MYSQL connection for two database if both database is on same server and accessible by same user. You can simply use the database name before table name. Look at below code.
Multiple MYSQL Database Connection with Zend Framework
Do you want to make a connection with multiple database in Zend Framework? Today i worked on multiple MYSQL database connection in Zend Framework as my client wants separate database to reduce the load of site. Its very easy to manage multiple database connection with ZF. You just need to add below code in bootstrap.php file and use the db object accordingly.
Find a Lat/Long with in x miles/kilometer Radius
You are at the right place if you are looking for solution to get or check latitude and longitude is with in x miles of radius with given latitude and longitude. This is very easy with a single equation. Get all lat/long list from database if current lat/long is with in x miles of radius.
MYSQL Split/Explode function
Do you know any MYSQL split function or Explode function ? I guess no, as MYSQL does not have any function for split string or explode string. Today i need to explode one of my database field which contains latitude and longitude.
Search MySql records Group By Year from DateTime
I am working with Mobile Ad networking site for one of my client and i wanted to get the yearly records from datetime field. Actually i am transferring hourly data in to different table to reduce load time of reporting page. For this, i need to combine records by yearly from date or datetime field
Search MySql records Group By Month from DateTime
I am working with Mobile Ad networking site for one of my client and i wanted to get the monthly records from datetime field. Actually i am transferring hourly data in to different table to reduce load time of reporting page. For this, i need to find the monthly record from date or datetime field.
Difference between IN and FIND_IN_SET
You may be confused with IN() and FIND_IN_SET() MYSQL functions. There are specific case/situation for both functions where to use which Mysql function. IN() function is used when you have a list of possible values and a single value in your database.
I am 
Recent Comments