Home / database
Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
How to Setup a MySQL DB Cluster in Docker ( Docker DB Cluster)

How to Setup a MySQL DB Cluster in Docker ( Docker DB Cluster)

Add Comment Edit
  Video Tutorial Blog Tutorial 1. At first clone the repo      git clone http://github.com/shawon100/docker-mysql-db-cluster 2. Then open t...
Read More
[MySQL] Online Judge User's Unique Total Solved Problem Query

[MySQL] Online Judge User's Unique Total Solved Problem Query

Add Comment Edit
SELECT DISTINCT sname, COUNT(verdict) AS verdict FROM ( SELECT * FROM submission where verdict='Accepted' and sname='sh...
Read More
[MySQL] After Insert Trigger Sum all value of a column

[MySQL] After Insert Trigger Sum all value of a column

Add Comment Edit
CREATE TRIGGER `mytrigger` AFTER INSERT ON `iot`  FOR EACH ROW BEGIN    DECLARE a float;    DECLARE b float;    DECLARE c float; ...
Read More
[MySql] Sort Contents based on two different value

[MySql] Sort Contents based on two different value

Add Comment Edit
A very important Sorting query that sort contents of a table according to two values. if values are equal based on first value then it...
Read More
Subscribe to: Posts ( Atom )