MySQL Database Management Fundamentals
Database Concepts and Initialization
A database is a repository for structured data storage and management.
Service Management Commands
net start mysql
net stop mysql
mysqladmin -u root password new_password
mysql -u root -p
SQL Statement Categories
Type
Full Name
Purpose
DDL
Data Definition Language
Defines database objects
DML
Data ...
Posted on Tue, 28 Jul 2026 16:20:57 +0000 by orangehairedboy
MyBatis SQL Query Implementation Techniques
UNION operations combine results from multiple tables while eliminating duplicate records:
<resultMap id="TransactionResult" type="com.example.Transaction">
<id column="txn_id" property="id"/>
<result column="order_ref" property="orderReference"/>
<result col ...
Posted on Tue, 14 Jul 2026 16:38:23 +0000 by r3dn3ck
SQLite Database Browser Interface and Features
DB Browser for SQLite Overview
DB Browser for SQLite is an open-source, cross-platform graphical tool for creating, designing, and editing SQLite database files. It provides an intuitive spreadsheet-like interface that enables users and developers to manage databases without needing deep SQL knowledge. Key capabilities include:
Create, compact ...
Posted on Thu, 09 Jul 2026 17:31:06 +0000 by Alelinux
SQL Database Fundamentals and Practical Examples
Datbaase Schema Setup
The following SQL script creates a student information database with four tables: major, stu (students), cou (courses), and sc (student-course enrollments).
-- Create and use database
DROP DATABASE IF EXISTS stuinfo;
CREATE DATABASE stuinfo;
USE stuinfo;
-- Majors table
CREATE TABLE major (
mno INT PRIMARY KEY,
mn ...
Posted on Sun, 10 May 2026 20:33:27 +0000 by jzimmerlin