I have multiple many to many relations related with one main entity.
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.
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:
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
I want to extract results from EAV (entity-attribute-value) tables, or more specifically entity-metadata tables (think like wordpress
wp_postmeta) as a “nicely formatted relational table”, in order to do some sorting and/or filtering.
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.
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.
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 …
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?
In my block code I am trying to programmatically retrieve a list of products that have a attribute with a specific value.