## How to count field with multiple values in MYSQL

I have a MySQL database and Table1 has a column that can get four distinct values e.g 1,2,3,4. Is it possible to create one query to count 4s and all the other values together?

For example

``     column1 row1    1 row1    4 row1    2 row1    4 row1    3 ``

should produce 2 and 3, two 4s and the rest values.

## Is having multiple correct passwords for a single username a security problem?

This question occurred to me when using online banking. My wife and I have a joint account. The username to login to internet banking is just our account number, so it is the same for both of us. Nevertheless the bank supplied us with 2 distinct passwords.

If the passwords where only given out by the bank and we would log into the same account this would probably be fine.

But first the bank actually forces us to each choose our own new password. In theory I could choose the same password as my wife and then the system would tell me ‘you can’t use this password because it is already taken’ or something like that so I would have guessed my wifes password. Seems securitywise very shady.

Secondly although we access the same money in the bank account we don’t have the exact same user account in the bank as for some actions the identity of the user is needed (for example ‘please send a new credit card’, should it be for me or for my wife?). The situation of one username combined with one password accesses one user account, the same username with another password accesses a different user account looks to me like a severe breach of security.

Is this actually fine or is the bank using some very sloppy and potentially unsafe programming for their joint accounts?

## What are the most effective use of L1-3 spell slots for healing multiple party members for a Cleric/Druid multi-class build?

What are the most effective use of L1-L3 spell slots for healing multiple party members for a Cleric/Druid multi-class build?

I’m looking for some guidance on the most “cost” effective use of my L1 to L3 spell slots for a multiclass Cleric (Life Domain) / Druid (Circle of the Shepherd). I want to work out how to get the most overall healing, while trying to maximise the synergy of my domain/circle features.

The party consists of 6 players normally.

The maximum spell-slots available for L1-L3 spells are:

• 4 x 1st-level spells
• 3 x 2nd-level spells
• 3 x 3rd-level spells

Level 5 Cleric (Life Domain) (PHB p.60)

• Disciple of Life: +2 + spell level (target of the spell)

Level 5 Druid (Circle of the Shepherd) (XGE p.24)

• Spirit Totem, Unicorn Spirit: + druid level (all players)

I’m trying to think of how to best use my spell slots in combination with my Spirit Totem (Unicorn) and my Disciple of Life feature.

I think I’ve worked out a good single or combination for L1 slots…

For Level 1 slots I thought the best one is Cure Wounds:

• one character gets: 1d8 + spellcasting mod (+5 max); +3; +5
• all party members get: +5 (x6)
• Average: (4.5+5+3+5) + (5×6) = 47.5

In a pickle, use bonus action to cast Healing Word as well:

• one character gets: 1d4 + spellcasting mod (+5 max); +3; +5
• all party members get: +5 (x6)
• Average: (2.5+5+3+5) + (5×6) = 45.5

Average of both cast in the same round: 93

I’m not sure for L2 slots, and L3 slots I think Mass Healing Word would be the obvious choice?

## HongKong SEO multiple IPS server in stock

E3-1230v5 /64GB /2x4TB /100Mbps-1G VL 64GB 2x4TB SATA Unlimited/100M 1 \$ 299.00
E3-1230 v5 /64GB /2x480GB SSD /100Mbps-1G VL 64GB 2x480GB SSD Unlimited/100M 1 \$ 299.00
Xeon L3426 /4GB /2x500GB /100Mbps (PL) 4GB 2x500GB SATA Unlimited/100M 1 \$ 125.00
E3-1230 v2 /8GB /2x1TB /1Gbps (PL) 8GB 2x1TB SATA Unmetered/1G 1 \$ 269.00
E3-1230 v2 /8GB /2x3TB /1Gbps Direct Routing China (PL) 8GB 2x3TB SATA Unmetered/1G 1 \$ 750.00
Rosalie
Skype ID:live:.cid.143257f04d8bf604
Telegram:@rosalie269
Email:brittney@vpb.com

## Combining Game Effects and Combining Magical Effects – how does this relate to spells with multiple effects?

Combining Game Effects and Combining Magical Effects – how does this relate to spells with multiple effects?

Here is the information from the Dungeon Master’s Guide and the Player’s Handbook that relates to my question.

Combining Game Effects:

Different game features can affect a target at the same time. But when two or more game features have the same name, only the effects of one of them —the most potent one— apply while the durations of the effects overlap. For example, if a target is ignited by a fire elemental’s Fire Form trait, the ongoing fire damage doesn’t increase if the burning target is subjected to that trait again. Game features include spells, class features, feats, racial traits, monster abilities, and magic items. (DMG p. 252)

Combining Magical Effects:

The effects of different spells add together while the durations of those spells overlap. The effects of the same spell cast multiple times don’t combine, however. Instead, the most potent effect—such as the highest bonus—from those castings applies while their durations overlap. For example, if two clerics cast bless on the same target, that character gains the spell’s benefit only once; he or she doesn’t get to roll two bonus dice. (PHB p. 204)

How does the information above interact with spells that have multiple effects? I have used three spells as examples because each of them represents a nuance, but they could all combine to provide an answer: Blindness/Deafness (PHB p. 219), Bestow Curse (p. 218) and Contagion (p. 227).

For Blindness/Deafness (separate conditions): If this is cast twice, once to cause Blindness and once to cause Deafness, does this mean that the creature is both blind and deaf? Or, because it’s part of the same spell, only one of the effects is present – if so, which one?

For Bestow Curse (various curses): If two separate casters bestow separate curses on the same creature, do both curses remain in place? If so, how does we decide which one is active?

For Contagion (natural diseases): If you cast Contagion multiple times, to cause different natural diseases, would the creature have multiple diseases active, or only one of them?

I appreciate your thoughts on this.

## How to build simple jsonb object out of multiple arrays in postgres?

If I have three (or more) Postgres arrays with the same number of elements, and I want to build a multi-level JSONB object out of them—how can I do this?

Example:

``create temp table tbl1 as   select     array['a', 'b', 'c'] as keys,     array['d', 'e', 'f'] as val1,     array['g', 'h', 'i'] as val2; ``

Then I can do:

``select jsonb_object(keys, val1) from tbl1; ``

And get:

``{"a": "d", "b": "e", "c": "f"} ``

Likewise I can pass `val2` and get:

``select jsonb_object(keys, val2) from tbl1;           jsonb_object           --------------------------------  {"a": "g", "b": "h", "c": "i"} (1 row) ``

But I can’t see how I could get the following object:

``{   "a": { "val1": "d", "val2": "g" },   "b": { "val1": "e", "val2": "h" },   "c": { "val1": "f", "val2": "i" } } ``

I’m aware of `jsonb_build_object()` but that doesn’t seem to fit here.

How could the above result be created?

## How Dijkstra’s algorithm forms shortest path tree when multiple nodes have same shortest path length

I came across following problem:

Consider below graph:

What will be the shortest path tree starting with node $$A$$ returned by Dijkstra’s algorithm, if we assume priority queue is implemented as binary min heap?

My solution:

I referred Dijkstra from CLRS:

With A as a starting node, we will have priority queue bin min heap as follows:

``A{root, 0}     | Rest all:{∅,∞} ``

(Notation: `{parent in SPT, shortest path weight}`)

It will extract A from priority queue and add it to SPT and will relax AC and AB:

``    B{A:5}      /  \ C{A:6}  Rest all:{∅,∞}  ``

It will extract B from priority queue and and add it to SPT:

``   C{A:6}       | Rest all:{∅,∞}  ``

and will relax BE:

``            C{A:6}              /   \ Rest all:{∅,∞}   E{B,6} ``

Next it will extract C and so one. Thus the SPT will be:

But not:

Q1. Am I correct with above?
Q2. CLRS algo does not dictate which node to add to SPT if multiple of them have same shortest path weight. Hence its dependent on how priority queue is implemented. If no information was given about how priority queue was implemented then we cannot tell how SPT will be formed. Am I right?

## Can the cantrips gained from the Dragonmark feat be cast multiple times?

The Dragonmark Feat from Unearthed Arcana: Eberron says:

You gain the ability to innately cast spells and cantrips, as summarized in the Dragonmark Benefits table, using the spellcasting ability listed under the Ability column. You cast each spell at its lowest level. Once you cast a given spell this way, you must finish a long rest before you can cast it innately again. You must still expend any material components.

Every dragonmark gives the character access to a first, second and third level spell, as well as a cantrip. The second and third level spells can only be cast if the character is of high enough level (, 5th and 9th, respectively).

Usually you can cast the cantrips you know infinitely often. But the way this feat is worded seems to imply, that the cantrips gained from dragonmarks are treated exactly like the other spells, which means their use is limited to once per day. I’m am not sure if I interpret this correctly, if this is intended this way, or just worded weirdly.