Category Archive for "Database"

Direct SQL Queries In Magento

Let’s assume we need to fetch data from direct database and we don’t want to use model in magento. At that time we can also access data direct from database using magento database connection and simple SQL query. Below is…

Read More

SQL constraints

FOREIGN KEY – Ensure the referential integrity of the data in one table to match values in another table CHECK – Ensures that the value in a column meets a specific condition NOT NULL – It will not accept NULL…

Read More

Get subcategories of a main category in magento

To insincere sales it is important that your store must be user friendly where user easily find his/ her needed product and easily navigate in store. one of important page in magento is to display subcategory of main category. i.e…

Read More

Add top links in magento

Magento is an ecommerce platform built on open source technology and which use MVC system. It is managing all request response using Model, View and Controller. So, all view file call base on controller mapping as per there configuration in…

Read More

Mysql functions

MySQL Group By Clause – The MySQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s). MySQL IN Clause – This is a…

Read More

How to import large Database in phpmyadmin xampp

When you work in your local system you may face problem while uploading large database. When you face such problem you can apply below solution for it. By default Xampp have database import limit as 2MB. So if you want…

Read More

Change magento admin password from database

To change admin password need to follow below steps: 1) Login to Cpanel or access Database 2) Go to phpmyadmin 3) click on sql section 4) Run below query (Note: please update NEWPASSWORD with your new password and ADMINUSER with…

Read More