MySQL Archives - The Only Tutorials

Learn how to stop long running SQL query in MySQL

Posted on September 11, 2013 by agurchand

Sometimes when you Run a SQL join query in phpMyAdmin, there will be a situation where the entire server will go down because of the long running SQL query.

To kill this long running SQL query, you need to access …

Select query between two given dates in MySQL, MS SQL

Posted on January 12, 2013 by agurchand

Its very easy to select records between two different date in MS SQL and MySQL. Same kind of query will work in both the SQL engines.

Here is the query note it down or memorize for the future use, Its …

How to connect two different Database in a PHP Class – Simple Script

Posted on October 30, 2012 by agurchand

Sometimes you may need to connect two different databases for a project and you may feel difficult to do that right?.

Don’t worry it’s really simple if you are using a PHP Class in your project.


private static function _connectDB1()

…

How to show only non duplicate records in mysql

Posted on October 20, 2012May 9, 2020 by agurchand

Consider the below is the table name “student”

s_id      name
----     ----
 1    |   a      
 2    |   b    
 3    |   c
 4    |   a
 5    |   d
 6    |   b
 7    |   e

Now there are plenty of duplicate records …

How to get the next auto_increment ID from Mysql Table

Posted on October 13, 2012 by agurchand

Use this php function to get the next auto_increment ID from a MySQL Table:

Function:


function get_next_auto_id($tablename, $id){
$sql     = "select $id from $tablename order by $id desc limit 1";
$query     = mysql_query($sql);
$row     = mysql_fetch_assoc($query);
return $row[$id] +

…