How can I do ‘insert if not exists’ in MySQL?

Use INSERT IGNORE INTO table. There’s also INSERT … ON DUPLICATE KEY UPDATE syntax, and you can find explanations in 13.2.6.2 INSERT … ON DUPLICATE KEY UPDATE Statement. Post from bogdan.org.ua according to Google’s webcache: 18th October 2007 To start: as of the latest MySQL, syntax presented in the title is not possible. But there are several very easy ways to accomplish … Read more

Is there a way to return literally nothing in python?

There is no such thing as “returning nothing” in Python. Every function returns some value (unless it raises an exception). If no explicit return statement is used, Python treats it as returning None. So, you need to think about what is most appropriate for your function. Either you should return None (or some other sentinel value) and add appropriate logic … Read more

Unable to locate tools.jar

Yes, you’ve downloaded and installed the Java Runtime Environment (JRE) instead of the Java Development Kit (JDK). The latter has the tools.jar, java.exe, javac.exe, etc.

Access Control Request Headers, is added to header in AJAX request with jQuery

What you saw in Firefox was not the actual request; note that the HTTP method is OPTIONS, not POST. It was actually the ‘pre-flight’ request that the browser makes to determine whether a cross-domain AJAX request should be allowed: http://www.w3.org/TR/cors/ The Access-Control-Request-Headers header in the pre-flight request includes the list of headers in the actual … Read more

AngularJS BootstrapUI Typeahead with object & selection functionality

The typeahead directive from http://angular-ui.github.io/bootstrap/ is very, very flexible and there are many ways of achieving the desired functionality. I’m presenting 2 of them here. Firstly, the typeahead directive uses syntax very similar to the AngularJS select directive. This gives you full control over a displayed label and the data bound as model value. So what you could do … Read more

Sleep function Visual Basic

Is there a simple sleep function in Visual Basic that doens’t involve thread. Something similiar like there exists in: C: sleep(1); We also tried this code: …but it didn’t work. It gave me this error: PInvokeStackImbalance was detected Message: A call to PInvoke function ‘Ganzenbordspel!Ganzenbordspel.Spel::Sleep’ has unbalanced the stack. This is likely because the managed PInvoke … Read more