inanzzz | MYSQL

1. 31/12/2021 Using same MySQL connection in AWS Lambda with Golang example
2. 17/08/2021 Using Kubernetes StatefulSet to persist MySQL data
3. 10/11/2020 Deploying a database driven Golang application to Kubernetes
4. 17/04/2020 Forcing go docker container to wait for MySQL container
5. 13/03/2020 Database CRUD operations within Golang
6. 28/02/2020 Merging specific column values from multiple rows into one with MySQL query
7. 28/02/2020 SQL query to concatenate multiple rows into one column with MySQL GROUP_CONCAT
8. 28/02/2020 SQL query to calculate subtotal of all items per orders with MySQL ROLLUP
9. 13/02/2020 Useful and interesting things to know
10. 23/12/2019 Database driven Golang applications and suggestions
11. 03/06/2018 Checking if MySQL database is up before issuing queries within docker
12. 29/05/2018 Connecting to a MySQL container with a SQL client from host OS
13. 15/05/2018 Workaround for ONLY_FULL_GROUP_BY feature in MySQL GROUP BY queries
14. 05/04/2018 Setting up MySQL root user with Ansible and Vagrant
15. 17/09/2017 When and when not to index fields in database
16. 27/01/2017 Concatenating values with comma in many rows by using MySQL group_concat
17. 29/07/2016 Connecting to Vagrant MySQL server with MySQL Workbench in host machine
18. 09/03/2016 Solution for MySQL error 'Cannot connect to local MySQL server through socket /var/run/mysqld/mysqld.sock'
19. 08/01/2016 Finding out which tables contain certain columns in database
20. 04/08/2015 Importing the content of a CSV file into a MySQL table
21. 19/06/2015 Searching a specific keyword in a string with find_in_set()
22. 29/04/2015 Getting the first and the last day of current week in MySQL
23. 12/04/2015 MySQL full-text search diffirences between IN BOOLEAN MODE and IN NATURAL LANGUAGE MODE
24. 21/11/2014 How to create, use and update materialised views
25. 16/08/2014 How to do full-text search in MySQL
26. 16/08/2014 MySQL full-text search IN BOOLEAN MODE minimum word length limitation
27. 29/06/2014 Insert a new record with INSERT IGNORE otherwise update with ON DUPLICATE KEY UPDATE
28. 17/05/2013 How to backup only triggers and stored procedures with mysqldump
29. 19/04/2013 Creating an example of stored procedure in MySQL
30. 19/04/2013 Creating an example of function in MySQL
31. 19/04/2013 Creating an example of after update trigger in MySQL for auditing purposes
32. 19/04/2013 Creating an example of after insert trigger in MySQL for auditing purposes
33. 19/04/2013 Creating an example view in MySQL