How to update a table from a query result of another table related to the first one?

Here is my attempt. What is the correct syntax to achieve this?

UPDATE table_a a    SET a.firstCreationTime = c.created_at  FROM (   SELECT created_at    FROM table_b b    WHERE a.id = b.id    ORDER BY b.created_at ASC    LIMIT 1 ) AS c; 

Queueing MySQL record inserts to avoid over-subscription of a related resource … table locking?

Given a simplified hypothetical of seats in a lifeboat, if I have the following setup with a lifeboats table and a seats table where each record is one occupied seat in the given lifeboat:

CREATE TABLE lifeboats (   id INT UNSIGNED NOT NULL,   total_seats TINYINT UNSIGNED NOT NULL,   PRIMARY KEY (id));  INSERT INTO lifeboats (id, total_seats) VALUES (1, 3); INSERT INTO lifeboats (id, total_seats) VALUES (2, 5);  CREATE TABLE seats (   lifeboat_id INT UNSIGNED NOT NULL);  INSERT INTO seats (lifeboat_id) VALUES (1); INSERT INTO seats (lifeboat_id) VALUES (1); INSERT INTO seats (lifeboat_id) VALUES (1); INSERT INTO seats (lifeboat_id) VALUES (2); 

I can find lifeboats with available seats by querying:

SELECT      l.id, l.total_seats, COUNT(s.lifeboat_id) AS seats_taken FROM     lifeboats AS l         LEFT JOIN     seats AS s ON s.lifeboat_id = l.id GROUP BY l.id HAVING COUNT(s.lifeboat_id) < l.total_seats 

What is the best way to ensure 2 clients do not grab the last seat in a lifeboat without implementing some coordinating process queue?

My only idea (assuming I’m trying to grab seat in lifeboat 2) is going LOCK TABLE rambo like:

LOCK TABLE seats WRITE, lifeboats AS l READ, seats AS s READ;  INSERT INTO seats (lifeboat_id) SELECT      id FROM     (SELECT          l.id, l.total_seats, COUNT(s.lifeboat_id) AS seats_taken     FROM         lifeboats AS l     LEFT JOIN seats AS s ON s.lifeboat_id = l.id     WHERE l.id = 2     GROUP BY l.id     HAVING COUNT(s.lifeboat_id) < l.total_seats) AS still_available;  UNLOCK TABLES; 

but this is not very elegant, needless to say.

(My environment is MySQL8/InnoDB)

Can a Way of Astral Self Monk use wisdom related scores for jumping?

I have several questions on the interactions between the Arms of Astral Self and the Jumping mechanics. According to the 3rd level feature, Arms of the Astral Self:

While the spectral arms are present, you gain the following benefits:

• You can use your Wisdom modifier in place of your Strength modifier when making Strength checks and Strength saving throws.
• You can use the spectral arms to make unarmed strikes.
• When you make an unarmed strike with the arms on your turn, your reach for it is 5 feet greater than normal.
• The unarmed strikes you make with the arms can use your Wisdom modifier in place of your Strength or Dexterity modifier for the attack and damage rolls, and their damage type is force.

The Jumping session of the PHB states:

Long Jump

When you make a long jump, you cover a number of feet up to your Strength score if you move at least 10 feet on foot immediately before the jump. When you make a standing long jump, you can leap only half that distance. Either way, each foot you clear on the jump costs a foot of movement.

This rule assumes that the height of your jump doesn’t matter, such as a jump across a stream or chasm. At your DM’s option, you must succeed on a DC 10 Strength (Athletics) check to clear a low obstacle (no taller than a quarter of the jump’s distance), such as a hedge or low wall. Otherwise, you hit it.

High Jump

When you make a high jump, you leap into the air a number of feet equal to 3 + your Strength modifier (minimum of 0 feet) if you move at least 10 feet on foot immediately before the jump. When you make a standing high jump, you can jump only half that distance. Either way, each foot you clear on the jump costs a foot of movement. In some circumstances, your DM might allow you to make a Strength (Athletics) check to jump higher than you normally can.

You can extend your arms half your height above yourself during the jump. Thus, you can reach above you a distance equal to the height of the jump plus 1½ times your height.

My questions would be, assuming that I have Arms of the Astral Self activated:

1. Can I use my Wisdom Score instead of my strenght score to determine my long jump distance?
2. Can I make a Wisdom (Athletics) check instead of a Strenght (Athletics) check?
3. Can I use my Wisdom modifier instead of my Strenght modifier to determine my high jump’s height?
4. Can the extra 5 feet range of the Arms of Astral Self be used when accounting for "extending your arms half your height above yourself" on the high jump, making it 1½ your height + 5 feet instead of only 1½ your height?

I am aware that some of the answers to these questions are up to DM discretion, so I would like to know, if possible, what would be the RAW interpretation and also how would you rule it in your games.

In advance, I’m extremely grateful to whoever takes time to answer these 🙂

Does a PF2e spellcaster who takes multiclass dedications into other spellcasting classes, and related spellcasting feats, gain more spell slots?

Ezren is a level 10 evocation wizard, and hence would have spell slots of the following levels:

+-------------+-----------------+ | Spell level | Number of slots | +-------------+-----------------+ |           1 |               4 | |           2 |               4 | |           3 |               4 | |           4 |               4 | |           5 |               4 | +-------------+-----------------+ 

However, at level 2 Ezren took the Sorcerer multiclass dedication. At level 4 he took Basic Sorcerer Spellcasting, and Bloodline Breadth at level 8.

How many spell slots does Ezren have in a given day? Is it:

+-------------+-----------------+ | Spell level | Number of slots | +-------------+-----------------+ |           1 |               6 | |           2 |               6 | |           3 |               6 | |           4 |               4 | |           5 |               4 | +-------------+-----------------+ 

Because at level 8, spellcasting archetype feats grant an additional spell slot of first, second and third level, AND the bloodline breadth feat increases each of these by one?

Or do these sources of spell slots not stack for some reason? Coming from fifth edition, a wizard who multiclasses sorcerer still has the same number of spell slots as a pure wizard, so I’d like to clarify my understanding here.

For anything video related.

Why are you selling this site?
No time to work on this.

How is it monetized?
Not monetized

Does this site come with any social media accounts?

How much time does this site take to run?
auto

What challenges are there with running this site?
Same as any website

Is it possible for the runtime and input size in an algorithm to be inversely related?

I’m wondering if it’s possible for algorithms that have monotonically decreasing runtime with the input-size – just as a fun mental exercise. If not, is it possible to disprove this claim? I haven’t been able to come up with an example or counterexample so far, and this sounds like an interesting problem.

P.S. Something like $$O(\frac{1}{n})$$, I guess (if it exists)

Help understanding a theorem Kleinberg proves related to sequence alignment

This is from Kleinberg’s Algorithm Design text (Theorem 6.14)

Let $$M$$ be an alignment of $$X$$ and $$Y$$. If $$(m, n) \notin M$$, then either the $$m^{\text{th}}$$ position of $$X$$ or the $$n^{\text{th}}$$ position of $$Y$$ is not matched in $$Y$$.

The theorem does not state that $$m, n$$ must be the last elements of $$X$$ and $$Y$$ respectively, but earlier, when introducing the topic, he uses $$m, n$$ to denote the last entries of the two strings. Which of these is correct?

Unrelated applications like games accessing ‘webcache’ related files

As title suggests im wondering if a game ,for example, has any business accessing ‘webcache_counters’.

After attempting to clean my webcachev01 file due to its oddly large filesize given the fact i dont use IE or Microsoft Edge at all, I noticed in processexplorer that alot of my random applications were accessing a file with the suffix ‘webcache_counters’ followed by a string of numbers I’d imagine to be a registry key.

Strange thing about this handle is that i cant view its properties nor close the handle. With the first saying that it is ‘Unable to query’ and the latter saying i lack administrative rights. To clarify I am the sole user and administrator on this machine.

All this is having me increasingly worried, ive been having recent fears of malware on my PC and this has appeared in my rigourous inquiry of my files and processes. How can an innocuous sounding file/handle bar me from even closing it in process explorer?

Create dynamic sql query to select all related data in DB based on entry table and ID

Hope all is well. I am hoping you can help me.

Problem Statement – I’m tasked to create a dynamic SQL statement which will select all related data from a given table where the Identifier is passed. For each table where the relevant data is found i would like the data to be exported onto a separate tab of within excel

If i was doing this manually done this i would perform the following queries and export the data onto each tab;

Select * from  Mason where id = 12345 Select * from  MasonContacts where Companyid= 12345  Select * from  MasonOpportunities  where Comid = 12345  

However given the sheer volume of tables this isn’t viable.

Step 1 : Type in my identifier (in this case my identifier is a field called "Id" in the Table "Mason") The query will always start from this table.

Table Name : Mason Field : Id = "12345"

Step 2 : Search against table "MasonContacts", search against the field "Companyid". Return all columns & records where the field "Companyid = 12345"

Table Name : MasonContacts Field : Companyid

Step 3 : Search against table "Mason Opportunities ", search against the field "Comid". Return all columns & records where the field "Company = 12345"

Table Name : MasonOpportunities Field : Comid