MYSQL – multiple many to many selection
I have multiple many to many relations related with one main entity.
entity-attribute-value
Entity-Attribute-Value Table Design
I am currently designing a database structure for the products section of an ecommerce platform. It needs to be designed in such a way that makes it possible to sell an infinite number of different types of products with an infinite number of different attributes.
Modeling Product Variants
I’ve been trying to model product variants and thought that I might need to use EAV. I might have been able to do it without EAV, but I’m concerned that I might have missed something. Here’s my design:
Improving a query using a lot of inner joins to wp_postmeta, a key/value table
am working with a wordpress website that is performing the following query, but I see this query is doing many inner joins and the website takes long to load and goes down a lot, and I have been trying to create a query that produces the same result but with no success yet
What is best performance for Retrieving MySQL EAV results as Relational Table
I want to extract results from EAV (entity-attribute-value) tables, or more specifically entity-metadata tables (think like wordpress wp_posts and wp_postmeta) as a “nicely formatted relational table”, in order to do some sorting and/or filtering.
Too many tables; MySQL can only use 61 tables in a join
What is the best way to export data from multiple tables in MySQL. I’m basically working with product details. Say a product has 150 attributes of data. How can I export that in a single row and then export it to a flat file in CSV or tabdelimited format.
Is using a Master Table for shared columns good practice for an entire database?
Below, I explain a basic design for a database I am working on. As I am not a DB, I am concerned if I am on a good track or a bad one so I wanted to float this on stack for some advice. I was not able to find a similar discussion that fit’s my design.
mysql table structure proposal?
is this table any good for mysql? I wanted to make it flexible in the future for this type of data storage. With this table structure, you can’t use a PRIMARY KEY but an index …
MySQL correlated subquery in JOIN syntax
I would like to provide a WHERE condition on an inner query by specifying innertable.id = outertable.id. However, MySQL (5.0.45) reports “Unknown column ‘outertable.id’ in ‘where clause’”. Is this type of query possible?
Magento – Retrieve products with a specific attribute value
In my block code I am trying to programmatically retrieve a list of products that have a attribute with a specific value.