Freaks City

User Creation and Authorization MySQL 5.7 and Earlier Versions In versions prior to MySQL 8.0, users could be created implicitly via the GRANT statement or explicitly using CREATE USER. The recommended approach is to create the user first and then assign privileges. Creating Users: -- Create a user with a password CREATE USER 'app_user'@'localh ...

The COUNT() functon is a fundamental aggregation operation in MySQL that calculates the number of rows matching specified conditions. Despite its usefulness, performance degradation often occurs when working with large datasets. This article examines the root causes of slow COUNT() operations and presents effective optimization strategies. Perf ...

Consider an exam record table exam_record that logs user attempts over several year. The table has the folowing structure: Field Type Null Key Extra Default Comment id int(11) NO PRI auto_increment (NULL) Auto-increment ID uid int(11) NO (NULL) User ID exam_id int(11) NO (NULL) Exam ID start_time datetime NO (NULL) Start time ...

SELECT Statement Fundamentals The SELECT statement is fundamental for retrieving data from databases. When used alone, it can access system parameters and configuration settings. -- View system parameters SELECT @@port; SELECT @@basedir; SELECT @@datadir; SELECT @@socket; SELECT @@server_id; SELECT @@innodb_flush_log_at_trx_commit; SHOW VARIABL ...

Technical Architecture Backend Framework: Spring Boot The backend infrastructure is built upon Spring Boot, a framwork designed to expedite the development of Spring-based applications. By adopting the principle of "convention over configuration," Spring Boot significantly reduces the need for manual boilerplate configuration. It offe ...

Extracting Characters from the Left Side Use left(source_text, char_count) to obtain a specified number of charcaters from the start of a string. SELECT LEFT('datastream_process', 9); -- Result: datastrea Extracting Characters from the Right Side Use right(source_text, char_count) to retrieve a defined number of characters from the end of a st ...

Backend Framework: Spring BootSpring Boot is designed to streamline the creation of stand-alone, production-grade Spring applications. By prioritizing convention over configuration, it significantly reduces the complexity of setup. Developers can launch applications instantly using embedded servers like Tomcat without deploying external WAR fil ...

The Misconception A common confusion arises when working with MySQL integer types. Many developers believe that specifying different values like int(1) or int(10) affects the actual storage capacity or maximum value of the integer field. This misconception often leads to unnecessary debates in code reviews and database design discussions. Techn ...

Project Overview As global demographics skew towards aging populations, efficient health tracking for seniors becomes critical. Traditional offline record-keeping lacks cohesion and accessibility, while older adults often miss crucial preventative care information. To bridge this gap, this document outlines the engineering of a Spring Boot-driv ...

Understanding MHA Failover MHA (Master High Availability) is a comprehensive solution for achieving high avaliability in MySQL environments. Here's how it works: Master Monitoring: MHA uses masterha_manager to start the monitoring process Pre-checks include SSH connectivity validation and replication health verification The master node is moni ...