this is probably a crazy question but I am curious if anyone else has seen this. I have a database with 150 fields and 717002 records in it. If I do a count on business type like this: SELECT COUNT(*) FROM contractors WHERE BusinessTypeString LIKE '%A5%';  I get 60898 records which is fine. But when I write out a statement to add in the headers and write it to an outfile I get 60604 which is 294 records less. No errors Below is the statement I used. SELECT   'BusinessName', 'DbaName', 'PhysicalAddressLine1', 'PhysicalAddressLine2',    'PhysicalAddressCity', 'PhysicalAddressProvinceOrState', 'PhysicalAddressZipPostalCode',    'PhysicalAddressZipCodePlus4', 'PhysicalAddressCountryCode', 'CorporateUrl',    '1stBusPocFirstName', '1stBusPocMiddleInitial', '1stBusPocLastName', '1stBusPocUsPhone',    '1stBusPocUsPhoneExt', '1stBusPocEmail' UNION (SELECT   BusinessName, DbaName, PhysicalAddressLine1, PhysicalAddressLine2,   PhysicalAddressCity, PhysicalAddressProvinceOrState, PhysicalAddressZipPostalCode,    PhysicalAddressZipCodePlus4, PhysicalAddressCountryCode, CorporateUrl,    1 stBusPocFirstName, 1 stBusPocMiddleInitial, 1 stBusPocLastName, 1 stBusPocUsPhone,    1 stBusPocUsPhoneExt, 1 stBusPocEmail    INTO OUTFILE '/home/VOB_Full.csv' FIELDS TERMINATED BY ','    OPTIONALLY ENCLOSED BY '&quot;' FROM contractors WHERE BusinessTypeString LIKE '%A5%');  Any ideas?
What is the difference between UNION and UNION ALL?
Automatic left and right commands Is it possible to automatically "add" \left and \right commands in front of all brackets? The source code should be left intact, but LaTeX should interpret every pair of brackets as if they were preceded by such commands. This is because adding \left and \right commands is time consuming and makes source code longer and less readable. I considered defining new commands such as \lb and \rb for \left( and \right), but it doesn't seem very elegant to me: what if I also want to add square brackets for example?  Any ideas? Thanks. Is there a name based virtual host SSH reverse proxy? I've grown quite fond of HTTP reverse proxies in our development environment and found the DNS based virtual host reverse proxy quite useful. Having only one port (and the standard one) open on the firewall makes it much easier for management.  I'd like to find something similar to do SSH connections but haven't had much luck. I'd prefer not to simply use SSH tunneling since that requires opening port ranges other than the standard. Is there anything out there that can do this?  Could HAProxy do this? Integrating MySQL with Python in Windows Consider this equation :   $$\sqrt{\left( \frac{dy\cdot u\,dt}{L}\right)^2+(dy)^2}=v\,dt,$$  where $t$ varies from $0$ to $T$ , and $y$ varies from $0$ to $L$.  Now how to proceed ?   This equation arises out of following problem :   A cat sitting in a field suddenly sees a standing dog. To save its life, the cat runs away in a straight line with speed $u$. Without any delay, the dog starts with running with constant speed $v&gt;u$ to catch the cat. Initially, $v$ is perpendicular to $u$ and $L$ is the initial separation between the two. If the dog always changes its direction so that it is always heading directly at the cat, find the time the dog takes to catch the cat in terms of $v, u$ and $L$.  See my solution below :   Let initially dog be at $D$ and cat at $C$ and after time $dt$ they are at $D'$ and $C'$ respectively. Dog velocity is always pointing towards cat.  Let $DA = dy, \;AD' = dx$  Let $CC'=udt,\;DD' = vdt$ as interval is very small so $DD'$ can be taken straight line.  Also we have $\frac{DA}{DC}= \frac{AD'}{ CC'}$ using triangle property.  $\frac{dy}{L}= \frac{dx}{udt}\\ dx = \frac{dy.udt}{L}$  $\sqrt{(dx)^2 + (dy)^2} = DD' = vdt \\ \sqrt{(\frac{dy.udt}{L})^2 + (dy)^2} = vdt $  Here $t$ varies from $0-T$, and $y$ varies from $0-L$. Now how to proceed? Pop up option are not popping up after snipping the area Why does Simplify ignore an assumption? Create custom fields with apex Anybody knows how to create custom text fields on salesforce.com objects using apex? Opening Ubuntu 20.04 Desktop on WSL2 I installed Ubuntu 20.04 (server/terminal) from the Windows 10 app store, and then after launching the Ubuntu Terminal via WSL2 (Windows Subsystems for Linux) , I installed Ubuntu Desktop and did several steps to try and get a desktop instance of Ubuntu 20.04 launched.  In short, the steps involved editing the .bashrc file, installing Xming, and then attempting to open the Ubuntu desktop in Xming with the &quot;startxfce4&quot; command.  However, &quot;startxfce4&quot; just doesn't open the desktop for me.  I can get programs to open with &quot;grun&quot; and the file explorer to open with &quot;gopen&quot; though, so it is working partially. Does anyone have any alternative suggestions to how I might get the terminal to open up the full Ubuntu Desktop?  Obviously, this wasn't what Windows had in mind with WSL2 so this is kind of a reach, but any input would be helpful.  Could I somehow do this from the file explorer or with a program that could opened from &quot;grun&quot; or &quot;gopen&quot;? Area 51 is miscounting my proposal followers I know of one person who is following my proposal who doesn't show up on the proposal webpage.    My proposal is for quantitative finance: .  It shows 19 people following the proposal (on the side of the page), and the total listed at the top of the page is 19 followers.  Yet one user is not listed: .  This makes me wonder if other followers are also not being counted? $\sum_{k=1}^nH_k = (n+1)H_n-n$. Why? How do I disable Dunst and go back to notify-osd? I installed i3, which recommends dunst, but I'm not using i3 at the moment, and the dunst notifications don't really fit with Unity. I'd rather not uninstall dunst totally, since I might want to start using it at some point in the future; is there a way to switch back to notify-osd without uninstalling dunst? Change installed AppleScript version How do you deserialize json properties that are reserved words in apex? Is there any way to deserialize JSON into an object using JSON.deserialize if some of the property names in the JSON are reserved words in apex? I want to do something like this:  string jsonString = '{"currency" : "ABC"}'; public class JSONResult {     public string currency; } JSONResult res = (JSONResult) JSON.deserialize(jsonString, JSONResult.class); system.debug(res);   but of course I get an error that the identifier name is reserved. When is the vector space of continuous functions on a compact Hausdorff space finite dimensional? I know that the vector space of all real valued continuous functions on a compact Hausdorff space can be infinite dimensional.  When will it be finite dimensional?  And how will I identify that vector space with $\mathbb{R}^n$ for some $n$? Workflow for developing add-on/script I'm trying to figure out a good workflow for developing scripts and add-ons in Blender. Here's what I'm currently doing as I try my luck with a PyNode add-on:   Open blender Create a text editor panel Open my script (external text file) Edit my script in a nice external editor Reload the script Save the .blend file Run the script   Now that I can see what my code does, this Blender instance has been modified, so I can't (make changes to my script and) run my script again. So I do this:   Close blender Open blender with the .blend from step 6 and repeat steps 4-7, over and over and over..   Is there a better workflow for this sort of thing? How to open a web page from my application? I want to make my WPF application open the default browser and go to a certain web page.  How do I do that? What does eno mean in network interface name 'eno16777736' for CentOS 7 or RHEL 7? Under consistent network device naming scheme, what does 'eno' stand for in network interface name eno16777736 for CentOS 7 or RHEL 7? How can I create a /dev/null-like "blackhole" directory? I would like to create a "/dev/null" directory (or a "blackhole" directory) such that any files written to it are not really written, but just disappear.   I have an application that writes out large temporary files to a directory. I have no control over the name of the files and I don't really care about the content of these files. I could write a script that periodically clobbers these files, but the files are written out very quickly and fill my disk. I'm looking for something cleverer. I want the application to "think" that it is writing out these files, when in fact, the writes are just being discarded at the other end.  Also see  old related thread. Is their a way to move multiple vertices gradually at a time? I have moved multiple vertices gradually but a set of vertices at a time not all at a time, as shown in the animation below (First I moved the four vertices from top, then three, then two and at last the last vertex).  I wanted to do the same thing as shown in the animation below but all at a time. Input field added through javascript not in PHP $_POST variable. How to fix this?