UPDATE statement to re-assign a numeric value based on a formula
UPDATE statement to re-assign a column value according to a numeric formula
What does the number in parentheses shown after Unix command names in manpages mean? Reusable functions in jQuery callback Will Stack Overflow's engine be (someday, or ever) open sourced? Is there a pattern to which Star Trek ships get the definite article? Some ships in Star Trek are referred to with definite articles. "The Enterprise", "The Defiant". Other ships are referred to without them. "Voyager", "Enterprise". Is there a pattern to or explanation for this behavior? Which profile details does an account merge preserve? When one has to merge two accounts, they're prompted by something like this with input fields for each account link:     Account 1:  Account 1 link.       Account 2:  Account 2 link.    When the merge completes, which account details are preserved, like the display name, or the profile description? Account 1, or account 2? how to make some border lines of a table thick and colored how to make some border lines of a table thick and colored (either vertical lines or horizental lines)?I tried Xcline but could not color it. Also I tried make the cline thick but failed. Intutitive meaning behind the formal definition of sufficient statistic? According to the definition of sufficiency, a statistic is sufficient for a parameter if the conditional distribution of $X$ given a value of statistic does not depend upon the parameter.   What I am trying to understand is how does conditional distribution of $X$ not being a function of the parameter fit into the intuitive meaning of sufficiency i.e statistic value holding the same amount of information as that of the respective sample. Acount suspension reason is only shown on the main site profile not meta Clarify or visualize the parameters involved for receiving the Curious badge Prove that if prime $p$ divide $a_{2k}-2$, then $p$ divide also $a_{2k+1}-1$. I'm looking for a screen capture tool working on MacOSX that will export the capture to animated gif. What "allocation unit size" should I use for a drive with a single NTFS partition? I'm formatting a 1TB external hard drive as a single NTFS partition.  This drive is mainly meant for storing media.  Should I choose something other than the default allocation unit size?  The options range from 512 bytes to 64K.  Are there any guidelines that I should use with partitions storing other data?  Should I stop poking around and just leave it at "default"? Exposing database IDs - security risk? I've heard that exposing database IDs (in URLs, for example) is a security risk, but I'm having trouble understanding why.  Any opinions or links on why it's a risk, or why it isn't?  EDIT: of course the access is scoped, e.g. if you can't see resource foo?id=123 you'll get an error page. Otherwise the URL itself should be secret.  EDIT: if the URL is secret, it will probably contain a generated token that has a limited lifetime, e.g. valid for 1 hour and can only be used once.  EDIT (months later): my current preferred practice for this is to use UUIDS for IDs and expose them. If I'm using sequential numbers (usually for performance on some DBs) as IDs I like generating a UUID token for each entry as an alternate key, and expose that. I'm creating a model for a 3D game that will eventually be exported using a custom Python script. This model makes heavy use of UV textures.  However, the project now references a bunch of images that are not used by any objects in the project. Example:    I don't want the first two, or the red_bubble.png image. However, I have no idea how to remove them from the project. Selecting one of them reveals that there are "2 users of the data" although I am not using it anywhere.  How can I get rid of these excess images? Geomagnetic reversal? I have always been told that the geomagnetic field acts "as if" there were a bar magnet inside the Earth. I now this is not true, but I feel that knowing what is actually going on would help me understand the answer to the question that I'm about to ask:  Why does geomagnetic reversal happen? Is it something gradual or relatively fast?  (What is the origin of the geomagnetic field? Can we answer my questions starting from this mechanism? Installing windows to dual-boot I'm looking to install 32-bit windows with IIS to dual-boot with my 64-bit edition of windows on a laptop. I have a ten gig partition on my harddrive - is this large enough for a simple Windows install and a few programs?   I've never dual booted before, so I'm not quite sure how easy it is to mess up the process. Can you recommend any tutorials on how to set up a dual-boot configuration on Windows? biblatex: Tighter integration of \textcite "in the flow of text" This question led to a new feature in a package:      Many biblatex citation styles feature the \textcite command which is "intended for use in the flow of text, replacing the subject of a sentence" (manual, section 3.6.2). At the moment, this works well for citations of single works -- e.g. (assuming the authoryear style), one may write in the source  The reference work is \textcite{knuth:ct:a}.   which will be typeset as     The reference work is Knuth (1984).   Citing multiple works, on the other hand, is somewhat tedious. If one simply writes (1):  Important works are \textcite{knuth:ct:a,knuth:ct:b,markey}.   the output is rather a list than a correct sentence (2):     Important works are Knuth (1984); Knuth (1986); Markey (2005).   One has to write (3):  Important works are \textcite{knuth:ct:a}, \textcite{knuth:ct:b}, and \textcite{markey}.   to get (4):     Important works are Knuth (1984), Knuth (1986), and Markey (2005).   Can \textcite be modified so that input (1) will yield output (4), hereby achieving a tighter integration "in the flow of text"?  \documentclass{article}  \usepackage[style=authoryear]{biblatex}  \addbibresource{biblatex-examples.bib}  \begin{document}  This is how \texttt{\textbackslash textcite} currently works:\\ Important works are \textcite{knuth:ct:a,knuth:ct:b,markey}.  \bigskip  But I'd like \texttt{\textbackslash textcite} to output the following:\\ Important works are \textcite{knuth:ct:a}, \textcite{knuth:ct:b}, and \textcite{markey}.  \printbibliography  \end{document} My international conference in Europe this May has been canceled due to the COVID-19. I have a ticket, purchased from TAP air Portugal, from Toronto, Canada to Lisbon. Because it is a non-refundable fare, they don't want to give a refund.  They won't allow me to reschedule later than May 31 of this year. This won't be useful for me.  What options do I have? I'd prefer to get a full refund.  (I am a US citizen if it matters)  Note: They offered to refund just the taxes, which is about 10% of the value. That's not horrible, but I'd rather have the whole thing returned. References in externalized pgfplots I was writing on an document with a lot of pgfplots in it. Because of the memory limitation in LaTeX and in order to save some compiling time I tried out the externalize command. With most of the plots it perfectly worked out. But when I use the \ref command, namely \ref{&lt;legendname&gt;} the legend gets lost and instead there is a ??.  I think this question in a way is similar to  and . But no answer to these questions could solve my problem. Even the use of xr and zref packages showed no effect.  Am I just missing something?    MWE of the maindocument:  \documentclass{article} \usepackage{zref-user} \usepackage{xr-hyper} \usepackage{pgfplots} \usetikzlibrary{pgfplots.groupplots} \usepgfplotslibrary{external}  \tikzexternalize \externaldocument{part1}  \begin{document} \input{part1} \end{document}     With part1.tex looking like this:  \begin{tikzpicture}     \begin{groupplot}[       group style= {  columns=3,xlabels at=edge bottom,                 y descriptions at=edge left,                 horizontal sep=2cm,group name=plots},     width=0.4\textwidth,     xtick=data,     legend columns=3]     \nextgroupplot[xlabel=site 1,legend to name=grouplegend]     \addplot coordinates {(1,20)(2,23)(3,24.5)};     \addlegendentry {AaAaA,BbBbB,CcCcC}%     \nextgroupplot[xlabel=site 2]     \addplot coordinates {(1,14)(2,16)(3,17)};     \nextgroupplot[xlabel=site 3]     \addplot coordinates {(1,10)(2,11.5)(3,12.25)};     \end{groupplot}   % Legend     \node at (plots c2r1.north) [anchor=south] {\ref{grouplegend}}; \end{tikzpicture}     I'm writing with MikTeX 2.9 and the latest updates of the packages used. For compiling I used the command pdflatex -enable-write18 &lt;file name&gt;.  I hope the MWE is short enough ;) and some knows how to solve this problem. Redirect output from all commands to file, not just last