Posts in 2021
-
Most votes on mysql questions 2
May 01, 2021 in FAQ
Most votes on mysql questions 2. #11 How to output MySQL query results in CSV format? #12 Which MySQL data type to use for storing boolean values #13 UTF-8 all the way through #14 How do I connect to a MySQL Database in Python? #15 What's the difference between utf8_general_ci and utf8_unicode_ci? #16 Retrieving the last record in each group - MySQL #17 How do I quickly rename a MySQL database (change schema name)? #18 INNER JOIN ON vs WHERE clause #19 How to get the sizes of the tables of a MySQL database? #20 Insert into a MySQL table or update if exists
Read all the top votes questions and answers in a single page. #11: How to output MySQL query results in CSV format? (Score: 1278) Created: 2008-12-10 Last updated: 2018-07-07 Tags: mysql, csv, quotes Is there an easy way to run a MySQL query from …
-
Most votes on mysql questions 10
May 01, 2021 in FAQ
Most votes on mysql questions 10. #91 What is the ideal data type to use when storing latitude / longitude in a MySQL database? #92 Delete all Duplicate Rows except for One in MySQL? #93 SQL query return data from multiple tables #94 How do I find the MySQL my.cnf location #95 How do I modify a MySQL column to allow NULL? #96 Error renaming a column in MySQL #97 How do I add indices to MySQL tables? #98 Copy/duplicate database without using mysqldump #99 MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client #100 How to declare a variable in MySQL?
Read all the top votes questions and answers in a single page. #91: What is the ideal data type to use when storing latitude / longitude in a MySQL database? (Score: 453) Created: 2008-10-01 Last updated: 2018-12-03 Tags: mysql, database-design, …
-
Most votes on mysql questions 1
May 01, 2021 in FAQ
Most votes on mysql questions 1. #1 Should I use the datetime or timestamp data type in MySQL? #2 How can I prevent SQL injection in PHP? #3 Why shouldn't I use mysql_* functions in PHP? #4 How do I import an SQL file using the command line in MySQL? #5 What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? #6 Installing specific package versions with pip #7 SQL select only rows with max value on a column #8 How to get a list of user accounts using the command line in MySQL? #9 How to reset AUTO_INCREMENT in MySQL? #10 Can I concatenate multiple MySQL rows into one field?
Read all the top votes questions and answers in a single page. #1: Should I use the datetime or timestamp data type in MySQL? (Score: 2820) Created: 2009-01-03 Last updated: 2018-08-13 Tags: mysql, datetime, timestamp, sqldatatypes Would you …
-
Most votes on multithreading questions 9
May 01, 2021 in FAQ
Most votes on multithreading questions 9. #81 Volatile vs Static in Java #82 What is a "thread" (really)? #83 Threads vs Processes in Linux #84 How to debug a single thread in Visual Studio? #85 How to timeout a thread #86 Running multiple AsyncTasks at the same time – not possible? #87 Difference between volatile and synchronized in Java #88 Difference between thread's context class loader and normal classloader #89 Maximum number of threads per process in Linux? #90 Use cases for RxJava schedulers
Read all the top votes questions and answers in a single page. #81: Volatile vs Static in Java (Score: 273) Created: 2010-03-11 Last updated: 2018-10-10 Tags: java, multithreading, concurrency, static, volatile Is it correct to say that static means …
-
Most votes on multithreading questions 8
May 01, 2021 in FAQ
Most votes on multithreading questions 8. #71 How to pause / sleep thread or process in Android? #72 How to pass parameters to ThreadStart method in Thread? #73 Does ruby have real multithreading? #74 How to properly stop the Thread in Java? #75 Why doesn't JavaScript support multithreading? #76 ThreadStart with parameters #77 What resources are shared between threads? #78 How to make a function wait until a callback has been called using node.js #79 If async-await doesn't create any additional threads, then how does it make applications responsive? #80 Why must wait() always be in synchronized block
Read all the top votes questions and answers in a single page. #71: How to pause / sleep thread or process in Android? (Score: 305) Created: 2009-10-05 Last updated: 2015-01-18 Tags: android, process, multithreading I want to make a pause between two …
-
Most votes on multithreading questions 7
May 01, 2021 in FAQ
Most votes on multithreading questions 7. #61 What's the difference between deadlock and livelock? #62 Why use a ReentrantLock if one can use synchronized(this)? #63 When should the volatile keyword be used in C#? #64 Getting the thread ID from a thread #65 C# version of java's synchronized keyword? #66 multiprocessing.Pool: When to use apply, apply_async or map? #67 Start thread with member function #68 What is the difference between atomic / volatile / synchronized? #69 How can I pass a parameter to a Java Thread? #70 What is the difference between asynchronous programming and multithreading?
Read all the top votes questions and answers in a single page. #61: What's the difference between deadlock and livelock? (Score: 341) Created: 2011-05-27 Last updated: 2016-06-20 Tags: multithreading, pthreads, deadlock, livelock Can somebody please …
-
Most votes on multithreading questions 6
May 01, 2021 in FAQ
Most votes on multithreading questions 6. #51 How to run a Runnable thread in Android at defined intervals? #52 Threading pool similar to the multiprocessing Pool? #53 How to use background thread in swift? #54 Timeout on a function call #55 How do I run a simple bit of code in a new thread? #56 Handling InterruptedException in Java #57 Running code in main thread from another thread #58 When to use AtomicReference in Java? #59 How many threads is too many? #60 Using module 'subprocess' with timeout
Read all the top votes questions and answers in a single page. #51: How to run a Runnable thread in Android at defined intervals? (Score: 371) Created: 2009-12-17 Last updated: 2017-09-05 Tags: android, multithreading I developed an application to …
-
Most votes on multithreading questions 5
May 01, 2021 in FAQ
Most votes on multithreading questions 5. #41 Java: notify() vs. notifyAll() all over again #42 Simple example of threading in C++ #43 Handler vs AsyncTask vs Thread #44 Avoid synchronized(this) in Java? #45 How do you kill a Thread in Java? #46 std::unique_lock<std::mutex> or std::lock_guard<std::mutex>? #47 Task vs Thread differences #48 time.sleep – sleeps thread or process? #49 What is a semaphore? #50 The calling thread cannot access this object because a different thread owns it
Read all the top votes questions and answers in a single page. #41: Java: notify() vs. notifyAll() all over again (Score: 391) Created: 2008-08-31 Last updated: 2011-12-29 Tags: java, multithreading If one Googles for “difference between …
-
Most votes on multithreading questions 4
May 01, 2021 in FAQ
Most votes on multithreading questions 4. #31 How to get the return value from a thread in python? #32 How to check if current thread is not main thread #33 What's the difference between Invoke() and BeginInvoke() #34 Is there an advantage to use a Synchronized Method instead of a Synchronized Block? #35 What is std::promise? #36 How to wait for all threads to finish, using ExecutorService? #37 Could you explain STA and MTA? #38 What is the meaning of the term "thread-safe"? #39 Do zombies exist … in .NET? #40 What is the difference between task and thread?
Read all the top votes questions and answers in a single page. #31: How to get the return value from a thread in python? (Score: 422) Created: 2011-08-01 Last updated: 2019-05-05 Tags: python, multithreading The function foo below returns a string …
-
Most votes on multithreading questions 3
May 01, 2021 in FAQ
Most votes on multithreading questions 3. #21 Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on #22 What is the difference between ManualResetEvent and AutoResetEvent in .NET? #23 The difference between the Runnable and Callable interfaces in Java #24 Why is lock(this) {…} bad? #25 Programmatically find the number of cores on a machine #26 What is the purpose of Looper and how to use it? #27 When to use Task.Delay, when to use Thread.Sleep? #28 How can one use multi threading in PHP applications #29 Undefined reference to pthread_create in Linux #30 The application may be doing too much work on its main thread
Read all the top votes questions and answers in a single page. #21: Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on (Score: 617) Created: 2008-09-26 Last updated: 2013-07-30 Tags: c#, …