How to Create a WordPress Page to List All Comments?
I have created this page and this page and this page to show all the comments page by page. So that you can keep a track of all comments …
Category: sql
How to List the Most-Voted Posts in a Year using SQL?
In this post, we learn how to use SQL list the most popular posts (according to the number of comments for each posts). This posts, we will get some …
How to Make SQL Insert Statement Simply Faster?
If you have lots of rows to insert into a MySQL table, you might experience it taking ages to complete. For example, I have around 100K rows to insert …
How to Use Naive Bayes to Make Prediction (Demonstration via SQL) ?
The prediction algorithms in the domain of machine learning are all about the probability. The probability is how we represent the likelihood for an event to occur. It is …
The K Nearest Neighbor Algorithm (Prediction) Demonstration by MySQL
The K Nearest Neighbor (KNN) Algorithm is well known by its simplicity and robustness in the domain of data mining and machine learning. It is actually a method based …