How to Execute Custom Query in magento.?

Executing Custom Query in magento.
When you are working with the custom Magento development then we need use specific custom queries to get the desired result respectively. Here we have arranged some of the most important queries for Magento developers.Use the below given code carefully for creating database connections, Insert, select, update, delete and truncate queries with Magento.

---

Create Database Connections In Magento:-

With the given code you will be able to read and write from the database tables for creating database connections.

<?php
$read= Mage::getSingleton('core/resource')->getConnection('core_read'); 
//Only for reading the data from the database tables
$write = Mage::getSingleton('core/resource')->getConnection('core_write'); 
// Only for writing the data into the database tables
?>

---

Custom Insert Query in Magento:-

For insert query we use the following code given below with specific results accordingly

<?php
$connection = Mage::getSingleton('core/resource')->getConnection('core_write');
// insert
$sql = "INSERT INTO `table_name` (`id`,`name`,'email',`data`) 
VALUES ('1','tutorialsmines','example@gmail.com','Hello! Welcome To Tutorialmines')";
$connection->query($sql);
?>

---

Custom Select Query In Magento:-

With the given code you can use Custom Select query in Magento for get the specific results respectively.

<?php
$read= Mage::getSingleton('core/resource')->getConnection('core_read');
$value=$read->query("select * from table_name");

while ($row = $value->fetch()){
print_r($row);// to print data
};

?>

---

Custom Update Query In Magento

With the given below code one can use custom update query in their code effectively.

<?php
 $write = Mage::getSingleton('core/resource')->getConnection('core_write');
 $write->query("UPDATE table_name SET
          table_column=column_value WHERE table_column=column_value ");
?>

---

Custom Delete Query In Magento:-

This code is used to write custom delete query in Magento for removing the specific things from Magento.

<?php
 $where = "id = 10";
 $write = Mage::getSingleton('core/resource')->getConnection('core_write');
 $write->query("delete from TABLE_NAME where field_name = 'value'");
?>

---

Custom Truncate a Table Query In Magento:-

For truncating a table query use the below code accordingly for removing tables respectively.

<?php
 $read= Mage::getSingleton('core/resource')->getConnection('core_read');
 $read->query("Truncate table table_name");
?>

---

---