I'm confused what is the relationship bewteen customer and a order. Most of websites says its One to many because One customer can place many order. If we see physically its many to many because there is customer and there…
enter image description here How to count notifications with a certain status and a certain user_id ? I have some data in notification table, how is the logic to calculate notification whose status is field 3 based on user_id 2…
What is the difference if I always use POST method to update a row in the MySQL or Cassandra database instead of PUT? I ask this because when I did research on that I read in some other questions that…
Case Inputs Mysql Version on both Prod and test: 5.7 Query: SELECT t1.id t1.accountId, t2.col1 FROM table1 t1 INNER JOIN table2 t2 ON (t2.Id = t1.id) WHERE 1 AND MOD(t1.id, 20) = 0 AND t1.col1 = 0 AND t1.col2 <=…
I have a field called EMAIL_ADDRESS. One of the records would be: [email protected], [email protected], [email protected], [email protected], [email protected] I wan to remove all yahoo addresses in my SELECT query to get: [email protected], [email protected], [email protected] If I use REPLACE(SM.SCORECARD_EMAIL_ADDRESS, '[email protected],', '') this…
Consider we have A,B,C,D,E,F,G,H columns in my table and if I make composite indexing on column ABCDE because these column are coming in where clause and then I want composite indexing on ABCEF then I create new composite indexing on…
I'm trying to update rows in a scores table based on the following logic: Get the feat_sum for ids that don't have a score. For each feat_sum that has a NULL score, get the row with the nearest feat_sum and…
I am trying to execute the below update query using GROUP_CONCAT but it is failing. Can anyone kindly help me in correcting it, moreover the statement must always start with the “update” keyword is the catch here as well. UPDATE…
This is Ahmad Raza. I'm working on E-commerce Project. I am trying to get product attributes on Product details page where user can select attributes before adding to cart. I have two color attributes of single product in my database…
public function updateMovie(Request $request, $id) { $request->title; $movie = DB::connection('mysql2')->select('UPDATE cb_video SET title='.$request->title.' WHERE videoid=' . $id); return response()->json(['status' => 'success', 'data' => $movie]); } I am trying to update title in db but its throwing me error of SQLSTATE[42000]:…