I've got this table in Postgres: create table test("Product id", "Product Name", "Category", "Operator", piece) as values (10, 'Carbonara', 'C1', 'User1', 1) ,(11, 'Spaghetti', 'C1', 'User2', 1) ,(12, 'Coke', 'C2', 'User1', 1) ,(10, 'Carbonara', 'C1', 'User2', 2) ,(11, 'Spaghetti', 'C1',…
On laravel 10 site I have 3 related tables : Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name'); ... $table->timestamp('created_at')->useCurrent(); }); Schema::create('tasks', function (Blueprint $table) { $table->id(); $table->foreignId('creator_id')->references('id')->on('users')->onUpdate('RESTRICT')->onDelete('CASCADE'); $table->boolean('completed')->default(false); ... $table->timestamp('created_at')->useCurrent(); $table->timestamp('updated_at')->nullable(); }); Schema::create('task_user', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('user_id')->unsigned()->index(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');…
There's a following table, called fields: And there's a dedicated table to store its values, called values I want to run a query to produce the following output: Finished | Faculity | Characteristic | Photo --------------------------------------------- 1 | Math |…
I have a problem updating the Laravel account table with its groups. I want Laravel to select that account's dropdown list ID in the pivot table, but it shows a duplicate dropdown list due to the wrong nested loop. What…
I have these tables: questions, participants, choices, and choice_participant (pivot table). I displayed the questions with their choices on the user's page (I used the radio box to select an option) and saved it to the table choice_participant. Sample table…
I want to count how many candidates contest has. I have 4 tables: CONTEST id name from until VACANCY id contest_id name description USER id name pivot table: USER_VACANCY id user_id vacancy_id My Contest model protected $fillable = [ 'name',…
I have table structures like this : jobs id name types id name job_type (pivot table) id job_id type_id tasks id description job_type_task (pivot table) id job_type_id task_id Notes : jobs has many types and vice versa job_type has many…
I have this table: product amount no_of_customers Prdct_1 100 9 Prdct_1 200 15 Prdct_2 50 2 Prdct_3 40 5 Prdct_3 80 5 Prdct_4 10 1 I want to join this with the below table product no_of_bills Prdct_1 6 Prdct_1 3…
I have data in the following format returned from my database: user_id | video_id | liked 0 341 1 1 765 1 0 534 1 3 981 1 I need to pivot this table into the following form: user_id |…
I was searching around for a way to implement a crosstab query in MySQL and found an answer from this post show dates in rows as dynamic columns in MySQL. I tried the query and got it to work but…