SQL syntax error - Why?
Syntax error due to using a reserved word as a table or column name in MySQL
Why my DAC works without GND and VCC? This is the most interesting thing I have seen! I have built a  that sends data (D0-D7) to a DAC (ADV2175). The design worked fine and I just have a low frequency alias noise (). This noise was present on all my ground planes (This is in prototyping stage and that's not unexpected from the test PCB).  I started tracing the noise path by disconnecting wires to see when the noise is gone. Surprisingly even after disconnecting all VCC and GND connections (+ all VREF and logics gone to 0 or 1) the noise was present yet. The more unexpected behavior is when the DAC is just connected to DATA port+ CLK pin (all coming from the source FPGA, NO VCC or GND), it continues working and a sine wave is produced (but with the same noise)!!!  First I thought it may receive its VCC/GND form the logic 1/0 fed into it but if it was correct, it should not have produce 0x00 and 0xFF levels, but it makes those levels correctly (I changed 0xFF data stage to another level and a notch appeared on top of the waves. this shows it can build oxFF correctly).    This is a big challenge for my PCB design, as if this device really takes its GND from the data port, instead of the dedicated pins, I will have a hard time for designing a reliable ground plane for it (the return voltage should go back to a logic noisy environment and analog-digital ground plane isolation may be impossible).  Can anyone explain what is happening there? Benefits of using QQ-plots over histograms In , Nick Cox wrote:     Binning into classes is an ancient method. While histograms can be useful, modern statistical software makes it easy as well as advisable to fit distributions to the raw data. Binning just throws away detail that is crucial in determining which distributions are plausible.   The context of this comment suggests using QQ-plots as an alternative means to evaluate the fit. The statement sounds very plausible, but I'd like to know about a reliable reference supporting this statement. Is there some paper which does a more thorough investigation of this fact, beyond a simple “well, this sounds obvious”? Any actual systematic comparisons of results or the likes?  I'd also like to see how far this benefit of QQ-plots over histograms can be stretched, to applications other than model fitting. Answers on  agree that “a QQ-plot […] just tells you that "something is wrong"”. I am thinking about using them as a tool to identify structure in observed data as compared to a null model and wonder whether there exist any established procedures to use QQ-plots (or their underlying data) to not only detect but also describe non-random structure in the observed data. References which include this direction would therefore be particularly useful. Migrated questions with a nonexistent author should still show the author's name in the questions list I just noticed . Its author doesn't have an account on this site, which makes it show up like this on the homepage:        It looks like a simple thing - but it gets in the way of the 'flow' of the page:        Couldn't we somehow get the author's name, so that migrated questions with authors that don't have an account here still show up, like this:        Much better. Please? Generalized mean value theorem I know and understand the mean value theorem. But at the moment I don't have the intuition to understand the generalized mean value theorem     If $f$ and $g$ are continuous on the closed interval $[a,b]$ and differentiable on the open interval $(a,b)$, then there exists a point $c\in(a,b)$ where$$[f(b)-f(a)]g'(c)=[g(b)-g(a)]f'(c).$$If $g'$ is never zero on $(a,b)$, then the conclusion can be stated as$$\frac{f'(c)}{g'(c)}=\frac{f(b)-f(a)}{g(b)-g(a)}.$$   What is the intuition? And how can you prove this (generally) ? Sharepoint 2010 - Deploy webpart as Feature scope = web Does the 2020 Apple M1 MacBook Pro support 2x daisy chained Thunderbolt Displays? The Apple Silicon based  supports Thunderbolt version 3 and I'm wondering if anyone has tried connection one to an ? Of course you'd need to use one of Apple's Thunderbolt 3 to Thunderbolt 2 converters. I also understand that this version is limited to supporting only a single 4K or 6K display, but since the original Apple Thunderbolt Display is only 2K I’d want to try and daisy chain these. Can I run more than one external display from the Apple Silicon M1 CPU/GPU based MacBook Pro (or Air)? My PDO Statement doesn't work I had two drives partitioned the same and running two RAID partitions on each.  One died and I replaced it under warranty for the same model.  While trying to partition it, the first partition can only start on sector 2048, instead of 63 that was before. Drive have different geometry as previous and remaining ones. (Fewer heads/more cylinders)  Old drive:  $ sudo fdisk -c -u -l /dev/sdb   Disk /dev/sdb: 2000.4 GB, 2000398934016 bytes 255 heads, 63 sectors/track, 243201 cylinders, total 3907029168 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x000aa189     Device Boot      Start         End      Blocks   Id  System /dev/sdb1   *          63   174080339    87040138+  83  Linux /dev/sdb2       174080340   182482334     4200997+  82  Linux swap / Solaris /dev/sdb3       182482335  3907024064  1862270865   fd  Linux raid autodetect   Remanufactured drive received from warranty:  $ sudo fdisk -c -u -l /dev/sda  Disk /dev/sda: 2000.4 GB, 2000398934016 bytes 81 heads, 63 sectors/track, 765633 cylinders, total 3907029168 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x000d0b5d     Device Boot      Start         End      Blocks   Id  System /dev/sda1            2048  ...   Why is that? What features of Mavericks are beneficial to you? This question serves to share and collect the enhancements that make a large difference to how you use your Mac.   Please post one feature per answer. Please also check to see if your answer has already been posted - duplicate answers will be deleted. To search answers for this question use  (directly from the question page) in addition to your search terms in the search box in the upper right hand corner of this page.  The best answers will not only list a feature, but provide details on how to configure that feature, and provide an image of how to use the feature to be more efficient or effective with Mavericks. If you draw two cards, what is the probability that the second card is a queen? Why using IN(...) when selecting on indexed fields, will kill the performance of SELECT query? Is there a way to programmatically deactivate Proces Builder & flows? Is there a way to soql procesbuilder to tun activation off?  For example  List&lt;Processbuilder&gt; pbColl = new List&lt;Processbuilder&gt;();   Processbuilder pb=[SELECT status FROM Processbuilder WHERE status Active];  for(Processbuilder turnoff : pb){             turnoff.status = false;             pbColl.add(pb)} update pbColl;   If not is there a simple way to turn all activated Processes off/on? Backup to Azure Storage Container: Shared Access Signature the only way? RESTORE FILELISTONLY FROM URL = '' WITH CREDENTIAL = '' fails in SQL Server 2016.  Copied script from SQL Server 2012 environment, successfully restoring from Azure Storage Container, with create credential statement, and it failed in 2016.  Error message "Forbidden".  Only after logging into the Azure Portal, creating a Shared Access Signature for the container, could I execute the restore, and only by not specifying the credential did the restore work.  No documentation advises that a SAS (Shared Access Signature) is required in SQL Server 2016 for Azure container backup / restore.  Is there another way to use T-SQL to access blob backups on Azure storage containers in SQL Server 2016, than using SAS?    Looking at the MSDN tutorial on how to configure the backup service SQL 2016 introduces, a SAS is used. Refer Consider a "wavefunction" $\psi(x)$, which has a Fourier transform $\tilde \psi(p)$  Suppose that we know, for each $x$, $|\psi(x)|^2$, and that we know, for each $p$, $|\tilde \psi(p)|^2$.  Have we enough information to reconstruct the "wavefunction" $\psi(x)$, that is, obtain the phase of the "wavefunction" for all $x$ (up to a global phase, we are only interesting to the relative phases between the $x$)? Responding to your "too localized" concerns Prove that you can make change for any amount greater than 7 cents using only 3 and 5 cent coins. I am pretty sure this question has something to do with the Least Common Multiple.    I was thinking that the proof was that every number either is or isn't a multiple of $3, 5$, and $8\left(3 + 5\right)$. If it isn't a multiple of $3,5$, or $8$, great. You have nothing to prove. But if it is divisible by one of them, I couldn't find a general proof that showed that it wouldn't be divisible by another one. Say $15$, it is divisible by $3$ and $5$, but not $8$. Calling Overridden Constructor and Base Constructor in C# I have two classes, Foo and Bar, that have constructors like this:  class Foo {     Foo()     {       // do some stuff     }      Foo(int arg)     {       // do some other stuff     } }  class Bar : Foo {     Bar() : base()     {       // some third thing     } }   Now I want to introduce a constructor for Bar that takes an int, but I want the stuff that happens in Bar() to run as well as the stuff from Foo(int).  Something like this:  Bar(int arg) : Bar(), base(arg) {   // some fourth thing }   Is there any way to do this in C#?  The best I have so far is putting the work done by Bar() into a function, that also gets called by Bar(int), but this is pretty inelegant. How to change Windows 7 date format? Is it possible to configure Windows 7 to use YYYY-MM-DD instead of DD/MM/YYYY as the date format? How? Where? MySQL: How to retrieve a random row or multiple random rows? This is a recurring question (see ,  and ), but I have a different spin.  Suppose I have a bunch of samples from a generic MCMC sampler. For each sample $\theta$, I know the value of the log likelihood $\log f(\textbf{x} | \theta)$ and of the log prior $\log f(\theta)$. If it helps, I also know the value of the log likelihood per data point, $\log f(x_i | \theta)$ (this information helps with certain methods, such as WAIC and PSIS-LOO).  I want to obtain a (crude) estimate of the marginal likelihood, just with the samples that I have, and possibly a few other function evaluations (but without rerunning an ad hoc MCMC).  First of all, let's clear the table. We all know that the harmonic estimator is the . Let's move on. If you are doing Gibbs sampling with priors and posteriors in closed form, you can use ; but I am not sure how to generalize outside of those cases. There are also methods that require you to modify the sampling procedure (such as via ), but I am not interested in that here.  The approach I am thinking of consists of approximating the underlying distribution with a parametric (or nonparametric) shape $g(\theta)$, and then figuring out the normalization constant $Z$ as a 1-D optimization problem (i.e., the $Z$ that minimizes some error between $Z g(\theta)$ and $f(\textbf{x}|\theta) f(\theta)$, evaluated on the samples). In the simplest case, suppose that the posterior is roughly multivariate normal, I can fit $g(\theta)$ as a multivariate normal and get something similar to a Laplace approximation (I might want to use a few additional function evaluations to refine the position of the mode). However, I could use as $g(\theta)$ a more flexible family such as a variational mixture of multivariate $t$ distributions.  I appreciate that this method works only if $Z g(\theta)$ is a reasonable approximation to $f(\textbf{x}|\theta) f(\theta)$, but any reason or cautionary tale of why it would be very unwise to do it? Any reading that you would recommend?  The fully nonparametric approach uses some nonparametric family, such as a Gaussian process (GP), to approximate $\log f(\textbf{x}|\theta) + \log f(\theta)$ (or some other nonlinear transformation thereof, such as the square root), and  to implicitly integrate over the underlying target (see  and ). This seems to be an interesting alternative approach, but analogous in spirit (also, note that GPs would be unwieldy in my case).