Tag Archives: mysql

How to add new custom category attribute in Magento

28th MAR 2011 | Posted by Vedran Subotic in Configuration, Database, Extensions, Integration, Magento
How to add new custom category attribute in Magento

Sometimes you need to extend functionality of Magento categories. There is several ways to do that, I will show you how it can be done.
You can do that by modifying and adding data into some of tables directly, but it can be waste of time if you don’t know what you are doing.
This post will describe how you can add new custom category attribute in your Magento store via sql_setup script.

Read more

53

MySQL transactions in Zend framework

20th DEC 2010 | Posted by Mladen Lotar in Tools & Frameworks, Zend
MySQL transactions in Zend framework

by jrdurao/sxc

Hi! Today I’m going to explain a part of Zend framework DB functionality. Transactions in general are quite useful, like temporary tables, but in most of situations unnecessary. Because of that, I’m going to explain when and how to use them through Zend framework. Read more

5

MySQL – Left, Right, Outer or Inner Join? No – the SELF JOIN

13th OCT 2010 | Posted by Mladen Lotar in Tools & Frameworks
MySQL – Left, Right, Outer or Inner Join? No – the SELF JOIN

Hi to all of you! Today, I’m going to explain SELF JOIN in MySQL – I’ll answer why and then how should you use it. Read more

4

Usage of temporary tables in MySQL databases

29th SEP 2010 | Posted by Mladen Lotar in Tools & Frameworks
Usage of temporary tables in MySQL databases

Hi! My recent project had some specific requirements regarding the work with database. Since DB server had some limitations (regarding number of queries), and fairly big number of queries that needed to be executed I created a solution that included temp tables. And now, I’d like to explain how to use them and why. Read more

2

Magento’s database layout and its EAV structure

15th SEP 2010 | Posted by Mladen Lotar in Database, Magento
Magento’s database layout and its EAV structure

Greetings fellow developers! Today I’ll try to explain the principles of EAV system and Magento’s implementation of it. This is a tutorial / explenation for beginners, so please be patient and even try to draw the logic on a paper if you don’t understand it. A small notice before we start. I won’t use specific SQL query examples since this will be a simplified example of principles of the EAV.
Read more

8

Locked Out from Magento admin?

12th DEC 2009 | Posted by Ivan Weiler in Administration, Magento
Locked Out from Magento admin?

Here’s the situation, you, client, webmaster, pet or whoever was playing with users and roles in your favorite store and deleted only main admin account or broke admin account privileges. If it happened to you and you’re locked out from your Magento store, read on.
Read more

44

Escape from EAV the Magento way

12th JUN 2009 | Posted by Branko Ajzele in Database, Magento
Escape from EAV the Magento way

One of the differences between Magento eCommerce platform and lets say WordPress, when looked from developer point of view, is “avoid raw queries” approach. For a web application, Magento is massive system. His database, although not so massive but surely breathtaking with around 220 tables forces you to use “eye candy” EAV model to do even simple things. Read more

20

Reset a WordPress Password from php My Admin – Quick and dirty

4th JUN 2009 | Posted by Zeljko Prsa in Wordpress
Reset a WordPress Password from php My Admin – Quick and dirty

While back when I wasn’t using a password manager like I am today I had a nasty habit of not remembering the password or the username or both for a particular wordpress site.

Read more

4

Magento MySQL database diagram

20th OCT 2008 | Posted by Tomislav Bilic in Database, Magento
Magento MySQL database diagram

If you worked with osCommerce, Zen Cart, CRE Loaded or any similar eCommerce platform before, you might find Magento database structure quite confusing when you see it for the first time. I advise you not to rush too much figuring out what is what by glancing through database. Try to spend first few hours getting familiar with some background. For purposes of flexibility, the Magento database heavily utilizes an Entity-Attribute-Value (EAV) data model. As is often the case, the cost of flexibility is complexity. Is there something in Magento that is simple from developers point of view?

Read more

27