Freaks City

After a prolonged break from coding, I found myself struggling to recall basic SQL syntax 😅 Reviewing my old SQL notes and adding some updates 😂 Primary references: MySQL Documentation: https://dev.mysql.com/doc/refman/8.0/en/tutorial.html Yi Bai Tutorial: https://www.yiibai.com/mysql "Learning SQL" by Alan Beaulieu Basic Operatio ...

Entity Mapping package com.example.domain; import jakarta.persistence.*; @Entity @Table(name = "t_account") public class Account { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long accountId; @Column(nullable = false, unique = true) private String login; @Column(nullable = false) priv ...

Configuration and Engine Setup Define connection parameters and construct the database URL string. Initialize the SQLAlchemy engine to handle connection pooling. DB_HOST = '127.0.0.1' DB_PORT = 3306 DB_USER = 'admin' DB_PASS = 'secure_password' DB_NAME = 'company_db' CONNECTION_STRING = f'mysql+pymysql://{DB_USER}:{DB_PASS}@{DB_HOST}:{DB_PORT} ...

Working with SQL proficiency forms the basis for using Python modules to interact with MySQL in production tasks. Installing and Importing the Driver Install the MySQL driver via package manager: pip install PyMySQL Import the module in code: import pymysql Connection Object Establishes a link to the database. Instantiate it using pymysql.con ...

Database Connection Setup Establishing a connection to the database is the initial requirement for acessing table metadata. The JDBC API provides the necessary tools for this operation. import java.sql.*; public class DatabaseMetadataReader { private static final String DB_URL = "jdbc:mysql://localhost:3306/test"; private sta ...

Purpose of Indexes Indexes serve a similar function to a book's table of contents, designed to enhance query performance. Types of Index Algorithms B-tree indexes Hash indexes R-tree indexes Full-text indexes GIS indexes B-tree Index Classification How Secondary Indexes Build B-tree Structure -- Process steps: -- 1. Extract column values from ...

When working with Hibernate in projects, we often need generic database operation classes. While Tk MyBatis provides convenient utilities with methods that only update non-null values, empty strings are still processed as valid updates. This article presents a utility solution for converting empty strings to null values, along with a custom ann ...

Downloading the Software Obtain MySQL 5.7.29 64-bit from the official MySQL archives or a trusted mirror. This guide uses the portable (zip) distribution which does not require installation wizard. Configuration Steps 1. Extracting the Archive Extract the downloaded zip file to your preferred installation directory. For example: E:\Database\mys ...

Oracle Database Behavior In Oracle databases, the distinction between an empty string ('') and a NULL value is effectively nonexistent; the database engine interprets them identically. This behavior differs significantly from other relational database systems. To demonstrate this, we can create a test table and observe how Oracle processes thes ...

JDBC Programming Steps 1. Register the driver (inform the Java program which brand of database is being connected to) 2. Get the connection (indicates that the process of JVM and the database process have opened a channel, this is inter-process communication, remember to close the channel after use). 3. Obtain the database operation object ...