Let's say I have this MySQL table: +--------------+----+-----------------+------------+ | val_critical | qs | code_critical | code_line | +--------------+----+-----------------+------------+ | 1 | YS | 4.01 - Passers | GX10-13686 | | 1 | YS | 3.03 - Chains | GX10-13686 |…
I have data in following format in an SQL table but need to present it differently. Name Property value Mark Gender Male Mark Age 45 Mark Weight 167 Chris Gender Male Chris height 188 I'd very much like to present/select…
I have the following table, containing timeseries data. All datapoints of one "dataset" have the same timestamp and value "const". The following example shows two of these "datasets". +-----------+----------+----------+-------------+ | timestamp | const | name | value | +-----------+----------+----------+-------------+ |…
I currently have this so I can show product results that say "Product data not found" in the meta_key "product_info" My current query is this SQL: SELECT * FROM `wp_postmeta` WHERE `meta_key` LIKE 'product_info' AND `meta_value` LIKE '%Product data not…
I am trying to save a simple belongsToMany relation into my database. First, my table: Schema::create('user_activity_log', function (Blueprint $table) { $table->unsignedBigInteger('activity_id'); $table->unsignedBigInteger('log_id'); $table->unsignedInteger('sets'); $table->unsignedInteger('reps'); $table->primary(['activity_id', 'log_id']); $table->foreign('activity_id')->references('id')->on('user_activities') ->onDelete('cascade') ->onUpdate('cascade'); $table->foreign('log_id')->references('id')->on('user_logs') ->onDelete('cascade') ->onUpdate('cascade'); }); My Log and Activity models have these…
I am trying to create a pivot table in Postgres from the following table named product_info: CREATE TABLE product_info ( ID varchar(10), date VARCHAR(20) NOT NULL, product VARCHAR(20) NOT NULL, product_cost integer ); INSERT INTO product_info(ID, date, product, product_cost) VALUES…
I have a PostgreSQL table which gives me the following output: country metric_code male female pensioners teenagers us metric_1 10 14 22 30 us metric_2 105 142 222 309 uk metric_1 15 13 9 21 uk metric_2 212 264 440…
I try to create a procedure that transforms the following table from: ID Visit Date 1234567 Cake 01.01.2023 1234567 Coffee 01.01.2023 1234567 Cake 02.01.2023 2345678 Coffee 02.02.2023 2345678 Coffee 03.02.2023 to: ID Cake Coffee 1234567 Max(Date) 02.01.2023 Max(Date) 01.01.2023 2345678…
I am using an SQL table to keep track of the number of meals given to students every day. The table is structured as follows: ID_Student MealDate MealType 1 2023-05-21 1 2 2023-05-21 1 1 2023-05-21 2 2 2023-05-21 2…
I'm working with a Postgres table named orders that looks like this: user_id product order_date 1 pants 7/1/2022 2 shirt 6/1/2022 1 socks 3/17/2023 3 pants 2/17/2023 4 shirt 3/13/2023 2 pants 8/15/2022 1 hat 4/15/2022 5 hat 3/14/2023 2…