auto increment second column
Concatenating a string and primary key Id while inserting
"States Party to" or "State Parties to" or "States parties to"? When discussing a treaty or international agreement, which is correct?  "There are 100 states party to the treaty." (for example, as used )  Or:  "There are 100 state parties to the treaty." (for example, as used )   Or: "There are 100 states parties to the treaty."  (for example, as used ) How can a company use money from stock investors when they are constantly being bought and sold? I've got a NI Traktor Audio 2 sound card I'd like to get working with Mixxx, but I don't seem to have any success so far. The card seems to be supported in Ubuntu out of the box, and it seems to work well with ALSA, but I cannot select it in Mixxx and I'm not sure whether is something I can do to make it see it (e.g. through).  So for testing purposes, on the command line I can execute aplay to check each channel:  aplay -D plughw:2,0,0 test.wav   and  aplay -D plughw:2,0,1 test.wav   That works well: I can hear the test sound on each channel (A and B)  The relevant output for this card using aplay -D is:  hw:CARD=TraktorAudio2,DEV=0      Traktor Audio 2, Traktor Audio 2      Direct hardware device without any conversions plughw:CARD=TraktorAudio2,DEV=0      Traktor Audio 2, Traktor Audio 2      Hardware device with all software conversions   From those 2 items on the output, plughw is the one that works, whereas hw doesn't.  The problem is that Mixxx only lets me select the hw card, which does not seem to work. I'd like to be able to select the plughw card, which is the one that's working.  I've tried suspending Pulse Audio as suggested by , but that did not seem to work. I also played around with an .asoundrc file similar to the one  (which was for an older model of this sound card), but also without success.  Any ideas on how to make Mixxx show the right card (and channel, while we are at it)?  Thanks! Today I was cut off in the middle of the following sentence:     Between Cook, Strauss, and Pietersen—   My friend said I was wrong. He said that for more than two entities, among/amongst are used, and that between is only for two entities.   I vaguely remember some rule like this, but I asked him to hear the whole sentence, which was:     Between Cook, Strauss, and Pietersen, they’ve notched up 56 centuries in Test cricket.   Should I have used among here? Seems correct to me to use between, but my friend was certain.   Another friend pointed out the following sentence:     I’m still choosing between Harvard, Yale, and MIT.    Certainly among doesn’t seem to fit here, and she, to me, was correct in using between. The computer gave me this output in a window:  E: Encountered a section with no Package: header E: Problem with MergeList /var/lib/apt/lists/archive.ubuntu.com_ubuntu_dists_natty_main_binary-i386_Packages E: The package lists or status file could not be parsed or opened.   How can I fix this? When using unicode-math, how do I get the original calligraphic alphabet back? I am happy with the great majority of what unicode-math does. But at times I find that I prefer a symbol the way it was before. With \varnothing and \complement, for example. In those cases I was able to save them under a different name before loading unicode-math, but this doesn't always work.  Right now I'm trying to access the \mathcal alphabet from plain LaTeX. How might I accomplish this?    Additional Question  I've been looking through unicode-math, trying to figure out where exactly the original \mathcal alphabet gets discarded, but I eventually gave up.  It would be interesting if someone could explain:   how/where the original \mathcal font is defined anyway, and what kind of 'switch' is thrown by unicode-math that makes it unavailable. How can I install updates and shut down from the command line? I know that there is a simple way to shutdown the computer in command prompt, but is it possible to do system updates and then shutdown the computer in command prompt?   For example, when Vista needs to install updates, it will let me install them and shut down by clicking the Shut Down button (while relegating the normal shut down button into the menu). So is there a command to do this in command prompt? Do I have to re-enter the Schengen area to activate my second visa when traveling on back-to-back Schengen visas? I currently have a valid multiple entry Schengen visa that expires on Feb 10th (issued by the Spanish consulate). I need to visit the Czech Republic from Feb 9th to Feb 15th. For this, I am getting a visa starting Feb 11th from the Czech consulate as I was advised that I cannot have two simultaneous visas.   Is it possible for me to enter Czech republic on the current visa on Feb 9th, and stay past its expiry up to Feb 15th using the new visa without leaving the Czech Republic? Will there be any likely problem either while entering or exiting Schengen zone (I am entering Schengen in Frankfurt)? I don't do math a long time, so I completely don't remember how to prove that: $$ \sum_{i=1}^\infty \frac{i}{2^i} = 2 $$  Can anybody help me? NewForm.aspx disappeared Cannot update grub with parameters on live USB I have booted from a live USB ("Try Ubuntu"), that also has a persistent option set (I used  to create one) to do some tests for .  I'm trying to test  (like ) by doing this  sudo nano /etc/default/grub sudo update-grub   The problem is that that last command gives me this:  /usr/sbin/grub-probe: error: failed to get canonical path of /cow.   It looks like /cow is the file-system that is mounted on /, according to:  :~# df Filesystem     1K-blocks    Used Available Use% Mounted on /cow             4056896 2840204   1007284  74% / udev             1525912       4   1525908   1% /dev tmpfs             613768     844    612924   1% /run ....   Is there a way for me to run update-grub? Find the value of $g'(0)$. Let $f: \mathbb{R} \rightarrow \mathbb{R}$ be a continuous function with $f(1) = 5$ and $f(3) = 11$. If $g(x) = \int_1^3 f(x+t)dt$ then find $g'(0).$   Please explain your answer. Review option on mobile phone not available? The other day I was looking at Stack Overflow on my Android phone. All is made very nice and all, but I could not find the Review button/link. Is it being implemented, did I miss it, or it is not available? The currently proposed Gravitational wave detection apparatus consists of Michelson Interferometer which is supposed to measure distances of the order of $10^{-22}$m. But the wavelength of the light used is in the order of micrometers ($10^{-6}$m). How is this possible? The conventional way to measure distance is by counting the interference fringes. But for path difference smaller than wavelength of laser light this is not possible. Exec format error of gcc-compiled Hello World c++ On AWS Ubuntu Server, I wrote C++ Hello, World program:  #include &lt;iostream&gt; using namespace std;  int main(){         cout&lt;&lt;"Hello, World!"&lt;&lt;endl;         return 0; }   And compiled it:  ubuntu@ip-xxxxx:~/dev/c++$ g++ -c ./test.cc -o out ubuntu@ip-xxxxx:~/dev/c++$ chmod a+x out ubuntu@ip-xxxxx:~/dev/c++$ ./out -bash: ./out: cannot execute binary file: Exec format error ubuntu@ip-xxxxx:~/dev/c++$ file ./out ./out: ELF 64-bit LSB  relocatable, x86-64, version 1 (SYSV), not stripped ubuntu@ip-xxxxx:~/dev/c++$ uname -a Linux ip-xxxxx 3.13.0-48-generic #80-Ubuntu SMP Thu Mar 12 11:16:15 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux ubuntu@ip-xxxxx:~/dev/c++$ gcc --version gcc (Ubuntu 4.8.4-2ubuntu1~14.04) 4.8.4   It seems that architecture x86-64 is the same each other. What is the problem here? Do I have to add more C++ flags? Why did sampling boost the performance of my model? I have an imbalanced dataset with 88 positive samples and 128575 negative samples. I was reluctant to over/undersample the data since it's a biological dataset and I didn't want to introduce synthetic data. I built a Random Forest Classifier with this original dataset. I got an F1 score of 0 for the positive class. Zero precision. Zero recall. I cross-checked the predictions and test data. The model predicts some positives none of which are actually positive. Worst performance.  So, I tried to oversample the positive class. I upsampled the positives to 1000 samples. To my surprise, the F1 score for this dataset was 0.97, for the positive class. Then I tried lesser samples. I was able to achieve an F1 score of 0.83 with 200 positive samples, which is just 2.25 times of the original positive samples.  I would like to know why this occurs. For 88 samples, F1 score is 0.00 (rounded off to two digits). For 200 samples it's 0.83. There is no data leakage. All the features are engineered. I used imbalanced-learn module for oversampling. Can someone explain why is this difference in performance? Is the Doctor Who episode 'Blink' the first use of the phrase "timey-wimey"? How to make an alias permanent? I have created an alias:  alias shh='sqlplus hfdora/hfdora@hfd1"     After creating this alias I was able to enter my database only by typing shh.  But after closing my shell, I wasn't able to find the alias next time. Even after typing only alias, shh was not showing in the list.  Is there any file to make an alias permanent so that it will not be erased? Why do RAW images look worse than JPEGs in editing programs? I've found that when you load a RAW image into an editing program such as Lightroom/Aperture, the image is usually worse than if you just took the image as JPEG. Now I understand that the camera does some magic during the JPEG conversion. But I'm trying to understand what that "magic" is.   If I'm looking to implement that "magic" myself on the desktop, what kind of settings should I be trying? I find that the RAW files have more extreme contrast. The dark areas for example are way darker than JPEG. Why is this? And what is the best way to fix this? New mobile chat doesn't follow the keyboard height The Japanese keyboard on iOS dynamically changes it's height to show suggestions and hides the input box of new mobile chat.        Additionally, third-party keyboards make the input box completely hidden. The chat seems to treat third-party keyboards as having no height.        iOS 9.2.1 / Mobile Safari  There is no problem in old (stable) design but it doesn't fix the input box to bottom!