I want to get out the minimum price for categories 1, 2 and 3 I've used LEAST(MIN(price_reduced),MIN(price)) IFNULL(MIN(price_reduced),MIN(price)) ... WHERE price <> 0 and price_reduced <> 0 Database id category price price_reduced 1 1 200 100 2 1 300 0…
I got the result of a query, and want to join it with a mockup table to fill the rows up to a certain number. this is an example where the query has two rows as result, but i always…
i want to handle the probable errors of mysql db. in my case, i have users table that has 7 columns. column email and username values should be unique and i set that for them. but in my sign up…
assume a table has id and date columns, is there a way to apply different date filter to each id? one way I can think of is to add a flag column that is populated with an if ladder if…
I'm trying to update the stock field or create it when the model doesn't exists The eloquent : AppModelsMarketingStock::updateOrCreate( ['marketing_id' => $attr['marketing_id']], ['product_id' => $attr['product_id']], )->increment('stock',$attr['qty']); The model : class MarketingStock extends Model { use HasFactory; protected $fillable = ['marketing_id','product_id','stock'];…
I have one column in MySQL which is return me comma separated value , I want to convert that column in to rows. Better answer then How to convert comma separated parameters to rows in mysql? select value from table…
I have a table such as follows: CREATE TABLE Associations ( obj_id int unsigned NOT NULL, attr_id int unsigned NOT NULL, assignment Double NOT NULL PRIMARY KEY (`obj_id`, `attr_id`), ); Now the insertion order for the rows is/will be random.…
I have three Table. The first Table contains a Rezipe with a id, the second Table contains the rezeptid with the ingredients and the third Table shows the ingredient with a restriction(vegan, meat...). Im looking for a way to select…
Here is the code of the (My)SQL function (it works outside of the function), but I can't manage to save it as a function for further reuse... This is an example of the working query: SELECT ( SUM(Items_Available * Store_Sales)…
This is my input table but i want to get this table Explaination: I want to subtract value of segmeted 14/10/22 - 7/10/22 that means (28930-28799) how could i get this kindly help me to figure it out. I cant…