I need to retrieve table parent-child relationship from "WHERE" clause like this:  select ... large list of fields with aliases ... from ... list of joined tables ...  where ((`db_name`.`catalog`.`group` = `db_name`.`catalog_group`.`iden`)  and (`db_name`.`catalog`.`iden` = `db_name`.`catalog_sub`.`parent`))   Is there a some regex to get identifiers from each condition? Say in an array element[0] = table from the left side, element[1] is table from right. Ident's name may be any. So only sql operators like 'where' 'and' '=' may be keys.  Any help would be greatly appreciated.  CLARIFY  I dont want to get references from WHERE clause by WHERE clause. I just want references as such. So as could I see there may be regex to replace all sequences   `.`    to   .    and then match all backticked pairs by   ` @ ` = ` @ `   Backticks around identifier always present in any may query by default. All string values surrounded by double quotes by default. I thought it's not a complex task for regex guru. Thanks in advance.  PS It's because myISAM engine does not support references I forced to restore in manually.  ENDED with:  public function initRef($q) {      $s = strtolower($q);     // remove all string values within double quotes     $s = preg_replace('|"(\w+)"|', '', $q);      // split by 'where' clause     $arr = explode('where', $s);      if (isset($arr[1])) {          // remove all spaces and parenthesis         $s = preg_replace('/\s|\(|\}/', '', $arr[1]);          // replace `.` with .         $s = preg_replace('/(`\.`)/', '.', $s);         // replace `=` with =                    $s = preg_replace("/(`=`)/", "=", $s);           // match pairs within ticks         preg_match_all('/`.*?`/', $s, $matches);         // recreate arr         $arr = array();         foreach($matches[0] as &amp;$match) {             $match = preg_replace('/`/', '', $match); // now remove all backticks             $match = str_replace($this-&gt;db . '.', '', $match); // remove db_name             $arr[] = explode('=', $match); // split by = sign         }         $this-&gt;pairs = $arr;      } else {         $this-&gt;pairs = 0;     }  }
I was writing some Unit tests last week for a piece of code that generated some SQL statements.  I was trying to figure out a regex to match SELECT, INSERT and UPDATE syntax so I could verify that my methods were generating valid SQL, and after 3-4 hours of searching and messing around with various regex editors I gave up.  I managed to get partial matches but because a section in quotes can contain any characters it quickly expands to match the whole statement.  Any help would be appreciated, I'm not very good with regular expressions but I'd like to learn more about them.  By the way it's C# RegEx that I'm after.  Clarification  I don't want to need access to a database as this is part of a Unit test and I don't wan't to have to maintain a database to test my code. which may live longer than the project.
Can you use your off-handed weapon for your main attack action? My friend is 2 weapon fighting a flesh golem. He has one sword that does lightning damage, and one sword that does fire damage. His right hand holds the lightning sword, and his left hand holds the fire sword.  My friend wants to attack with his left hand because lightning heals the golem. However, the DM says that because his left hand is his left hand, he can't use it as his "main" hand, and only attack with it. Is this rules as written/intended? When does the Death Saving Throw happen with respect to sources of automatic ongoing damage? If a character is knocked unconscious with 0HP with a source of automatically dealt damage, for example, into a fire, and takes damage from it each turn, does the automatic Death Saving Throw failure from taking damage at 0hp happen before or after the player's regular Death Saving Throw roll?  If the unconscious PC takes the auto-fail first then they effectively only get 1 Death Saving Throw to survive, because they'd autofail and roll a failure the first turn, then autofail again and die the next turn.   If they get to roll first, then they only effectively get two death saving throws before they die. The limit of a sum $\sum_{k=1}^n \frac{n}{n^2+k^2}$ as $n\rightarrow\infty$ Here is the proof I tried to weave while trying to prove this theorem:     Theorem. Every infinite subset of a countable set is countable.      Proof. Let $A$ be a countable set and $E\subset A$ be infinite. Then $A\thicksim\mathbb{N}$. This implies that there is a sequence $\left\{x_{n}\right\}_{n\in\mathbb{N}}$ where $x_{n}\in A$. Construct a sequence $\left\{n_{k}\right\}_{k\in\mathbb{N}}$ where $x_{n_{k}}\in A$, $n_{1}$ is the smallest positive integer such that $x_{n_{1}}\in A$, and $n_{k+1}&gt;n_{k}$. Then      $$ E=\bigcup_{k=1}^{\infty}x_{n_{k}}, $$      and $E$ is countable, because $E\thicksim\mathbb{N}$. $\blacksquare$   Is it convincing? We have previously determined that  or  can attune to magic items, but one of those is a sapient creature, and the other "always obeys your commands".  A paladin's steed (per the Find Steed spell) is also 'unusually intelligent' and falls within the score range for sapient creatures.  But what about a regular old animal? If my ranger has a wolf companion, can he make that wolf attune to, say, an Amulet of Health? According to the Beast Master archetype, a companion animal "obeys your commands as best it can".  Is spending an hour 'focused only on the item' (as required for attunement) something a beast can manage?  Or what if it's not an Animal Companion, but just a riding horse, a pet dog, a trained magpie?  I know, probably this is going to be down to the DM to determine, but is there any guidance we can use to help decide whether my cat can attune to an item, and whether rubbing it with catnip would help? Automatically adding user and password to openvpn script I have a working script, which allows me to do a vpn connection. It looks like this:  openvpn --config VPNBook.com-OpenVPN-Euro1/vpnbook-euro1-tcp443.ovpn   All is good, but I have to input the publicly available vpn and password every time I run this script. (Don't worry, I'm not going to do banking or anything serious over a free VPN, this is more for learning).  This is the username and the password available publicly on their website:  Username: vpnbook  Password: he2qv5h   After firing up, the script prompts me for username and password which now I need to copy and paste.   Tue Aug 15 11:54:51 2017 library versions: OpenSSL 1.0.2l  25 May 2017, LZO 2.08 Enter Auth Username: vpnbook Enter Auth Password:    Is there a way of doing it so the script inputs the values on its own?  I tried echoing it, but it isn't that easy.  Or do I have to edit the command itself, somewhere in the files? If yes, can someone point me in the right direction for doing it? what are the meanings of &quot;treated observation&quot; and &quot;non-treated observation&quot; in this context ?  Further, propensity score matching is a more robust method of matching that quantitative accounting researchers frequently use (Rosenbaum &amp; Rubin, 1983). With this technique, the researcher first estimates a logit or probit regression with the treatment effect as the dependent variable (i.e., S&amp;P 500 membership, continuing with our earlier example) and independent variables that are known determinants of the treatment (possibly economic performance, firm size, age, industry, etc. in our example). From this first-stage regression, the researcher obtains propensity scores. 6 The researcher then matches each treated observation to a non-treated observation based on the distance between their propensity scores (i.e., those observations with the closest propensity scores are matched). 7 Hoi et al. (2013) utilize propensity score matching in their study that links irresponsible CSR activities with tax aggressiveness. They first generate predicted propensity scores for each firm-year using a model of the determinants of a firm engaging in a high level of negative, irresponsible CSR activity. Then, they match a treatment firm (one with a high level of negative CSR activities) to a non-treatment firm (one with a low level of, or no, negative CSR activities) by matching observations with the closest propensity scores. Hoi et al. (2013) then re- test the relation between negative CSR activities and tax aggressiveness using this matched sample. These matching techniques help mitigate the researcher’s potential failure to consider certain firm characteristics that differ between treatment and non-treatment firms (Dhaliwal et al., 2012). Restore console session after remote desktop disconnects? Can Hydrogen Fusion via CNO Cycle Occur in First Generation Stars CNO cycle requires the presence of carbon, nitrogen and oxygen to undergo hydrogen fusion. Does this mean that for first generation stars, no matter how big they are, can't undergo hydrogen fusion by CNO cycle because there is no carbon, nitrogen and oxygen present?   I can't seem to find any website which mentions this. All they say is if a star is large enough, it will undergo hydrogen fusion via CNO cycle, they don't specifically mention it having to be a second generation star. If $A = \tan6^{\circ} \tan42^{\circ},~~B = \cot 66^{\circ} \cot78^{\circ}$ find the relation between $A$ and $B$ My trigonometric problem is:     If $A = \tan6^{\circ} \tan42^{\circ}$ B = cot$66^{\circ} \cot78^{\circ}$ find the relation between $A$ and $B$.    Working :   $$B = \cot 66^{\circ} \cot78^{\circ} = 1- \frac{\tan24^{\circ}+\tan18^{\circ}}{\tan42^{\circ}}$$  $$A= \tan6^{\circ} \tan42^{\circ} = 1- \frac{\tan6^{\circ} +\tan42^{\circ}}{\tan48^{\circ}}$$  but it seems  this is the wrong way of doing this...please suggest. Thanks! If I insert a flash drive and try to drag any files onto desktop - nothing happens.  Or from any other folder.  Drag 'n copy only works if you open desktop in nautilus ("show desktop in files").  I already ran the command:  gsettings set org.gnome.nautilus.preferences use-experimental-views false   It didn't help. How to fix this? I'm printing a tradeshow flyer and was wondering what type of paper I should print it on. I don't want anything glossy so I'm trying to decide on the following:   100# text weight matte 80# cover 80# matte   What is the difference between the types above? And how can I make a decision? I have a requirement to create triggers dynamically after a managed package is installed. I have read that the tooling API can be used to create triggers dynamically however it cannot be used in production. Is it possible to create triggers from a managed package in an org? I want to be able to create the trigger based on some user inputs. I'm a web developer, started to become a web designer. However, I think my understanding of colors is not practical yet. There are tools out there that can give you color harmonies, and more stuff, like , but they don't give you the start point. I mean, how should I know that for this web site, I'd better use green and for that website, choose red. How should I know that?  I think color selection is more like an art, instead of being a science, and I'm like "you should become an color artist, in order to become a web designer".  How can I improve my color selection skill? How to reduce space between image and its caption? Fan is always on, CPU usage is rather low and can't find the fan or thermal_zone proc files I have an Asus N76VB notebook with Ubuntu 14.04 and TLP for power managment. However, the fan is always on. It's not really loud, but it's annoying. My CPU usage is around 1-2%. It's clocked at 1.20 GHz.  I've added acpi=force to my boot parameters but it doesn't change anything.  /proc/acpi/fan: No such file or directory /proc/acpi/thermal_zone: No such file or directory   I've loaded all Asus ACPI modules.  lsmod | grep asus:  asus_nb_wmi            16990  0  asus_wmi               24191  1 asus_nb_wmi sparse_keymap          13948  1 asus_wmi video                  19476  2 i915,asus_wmi wmi                    19177  2 mxm_wmi,asus_wmi   Somehow, it can read the temperatures.  sensors:  acpitz-virtual-0 Adapter: Virtual device temp1:        +43.0°C  (crit = +108.0°C)  coretemp-isa-0000 Adapter: ISA adapter Physical id 0:  +44.0°C  (high = +87.0°C, crit = +105.0°C) Core 0:         +44.0°C  (high = +87.0°C, crit = +105.0°C) Core 1:         +42.0°C  (high = +87.0°C, crit = +105.0°C) Core 2:         +39.0°C  (high = +87.0°C, crit = +105.0°C) Core 3:         +39.0°C  (high = +87.0°C, crit = +105.0°C)  asus-isa-0000 Adapter: ISA adapter temp1:        +43.0°C     I really hope someone knows how to solve this. Almost all information I could find was about saving power to create less heat.    I got Intel and NVIDIA (GeForce 740M) graphics but I'm almost anytime on Intel.  $ sudo lshw -c display   *-display                       description: VGA compatible controller        product: 3rd Gen Core processor Graphics Controller        vendor: Intel Corporation        physical id: 2        bus info: pci@0000:00:02.0        version: 09        width: 64 bits        clock: 33MHz        capabilities: msi pm vga_controller bus_master cap_list rom        configuration: driver=i915 latency=0        resources: irq:43 memory:f7400000-f77fffff memory:d0000000-dfffffff ioport:f000(size=64)     fwts fan: How can I prove my publication list is mine? In some of the questions regarding author name, it is mentioned that people can use whatever they like, however, they must be consistent across their publications.  When it comes to being hired by a university for a tenure track position or by another principal investigator as a researcher, how can someone prove that they are the author of papers when their author name does not exactly match the one on their ID card? How can a principal investigator be sure that the publication list does actually belong to the person claiming them? Do Stack Exchange sites allow editing of comments and posts from other users? A nasty integral of a rational function I'm having a hard time proving the following $$\int_0^{\infty} \frac{x^8 - 4x^6 + 9x^4 - 5x^2 + 1}{x^{12} - 10 x^{10} + 37x^8 - 42x^6 + 26x^4 - 8x^2 + 1} \, dx = \frac{\pi}{2}.$$  Mathematica has no problem evaluating it while I haven't the slightest idea how to approach it. Of course, I would like to prove it without the use of a computer. Is this an explicit form of a special function I fail to recognize? What is the standard/recommended font to use in papers? I looked around but did not find that anyone has asked this before, but what are the fonts that are standard/recommended while writing academic reports/papers?