Essential MySQL Database Management Techniques
Table Creation and Data Types
Table creation falls under DDL statements. Each database contains structural files for its tables:
SHOW TABLES;
Display table structure:
DESCRIBE table_name;
SHOW COLUMNS FROM table_name;
Field Types
Integer Types
TINYINT (1 byte)
SMALLINT (2 bytes)
MEDIUMINT (3 bytes)
INT (4 bytes)
BIGINT (8 bytes)
Decimal Typ ...
Posted on Wed, 10 Jun 2026 17:38:24 +0000 by ntbd
Managing SQL Server Databases and Tables
Data Types
Various data types serve specific purposes within SQL Server. Each type has defined ranges and applications for optimal use.
Server Configuration
Server Properties via SERVERPROPERTY
Retrieve server information using the SERVERPROPERTY function:
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));
System Views for Server Details
Q ...
Posted on Mon, 18 May 2026 11:42:14 +0000 by ManicMax
Mastering SQL Data Retrieval, Constraints, and Relational Joins
Sorting Query Results
The ORDER BY clause controls how rows are returned. It does not alter the stored data, only the presentation.
SELECT column_list FROM table_name
WHERE condition
ORDER BY column1 [ASC|DESC], column2 [ASC|DESC];
Single‑column ordering
Sort employees by age in descending order:
SELECT name, age FROM employees ORDER BY age DE ...
Posted on Sun, 10 May 2026 02:14:43 +0000 by deffe
Understanding Database Constraints and Query Techniques in DaMeng
Database Constraints in DaMeng
What Are Constraints?
Constraints are rules enforced on table columns to insure data integrity. They guarantee both accuracy and validity of stored data.
Constraint Types
Primary Key Constraint
A primary key uniquely identifies each row in a table. This field must contain unique, non-null values.
Creating a table ...
Posted on Fri, 08 May 2026 01:03:03 +0000 by lostincoding