Mysql Standard

Use this for WordPress-adjacent MySQL work and future MySQL-backed utilities. Do not apply it to Protocol5 SQL Server code.

Metadata

Field	Value
Source site	aiwikis.org
Source URL	https://aiwikis.org/
Canonical AIWikis URL	https://aiwikis.org/aiwikis/files/wiki-global-coding-standards-mysql-md-92a134fe/
Source reference	wiki/global/coding-standards/mysql.md
File type	md
Content category	llm-wiki
Last fetched	2026-06-22T01:56:21.9510185Z
Last changed	2026-05-15T23:02:00.0545413Z
Content hash	sha256:92a134fee31328fc0eb59afc924616ff95afc08f32a895b9815a1580c6c8b020
Import status	unchanged
Raw source layer	data/sources/aiwikis/wiki-global-coding-standards-mysql-md-92a134fee313.md
Normalized source layer	data/normalized/aiwikis/wiki-global-coding-standards-mysql-md-92a134fee313.txt

Current File Content

Structure Preview

• MySQL Standard
• Schema
• Queries
• Migration

Raw Version

---
uai_id: "dd26376f-3ccd-499b-b597-a3553bbbd967"
type: "database-standard"
owner: "AIWikis maintainers"
status: "Reviewed"
source_system: "AIWikis.org global"
source_status: "local synthesis from WordPress and future MySQL-adjacent implementation practice"
sensitivity: "public-safe source-side memory"
agent_use: "load for MySQL schema, query, migration, and WordPress database-adjacent work"
lineage:
  - "wiki/global/coding-standards/index.md"
  - "wiki/uaix/index.md"
  - "wiki/llmwikis/index.md"
  - "wiki/index.md"
source_trace:
  - "wiki/global/coding-standards/mysql.md"
confidence: 0.78
confidence_label: "reviewed-local"
last_linted: "2026-05-08T00:00:00Z"
handoff_export: "include"
aliases:
  - "MySQL Coding Standard"
  - "MySQL Database Standard"
last_reviewed: "2026-05-15"
typed_relations:
  part_of:
    - "wiki/index.md"
  depends_on: []
  supersedes: []
  contradicts: []
  source_for: []
---
# MySQL Standard

Use this for WordPress-adjacent MySQL work and future MySQL-backed utilities. Do not apply it to Protocol5 SQL Server code.

## Schema

- Prefer WordPress APIs and schema helpers when operating inside WordPress.
- Use explicit character set and collation decisions for user-facing text.
- Keep indexes aligned with actual lookup predicates.
- Use stable slugs and keys for public content, not generated titles alone.
- Keep source ownership visible when storing cross-site memory.

## Queries

- Parameterize values through the owning framework or driver.
- Avoid per-row functions in hot predicates when a normalized or generated column can be indexed.
- Keep pagination explicit for large public inventories.
- Treat raw imported files as evidence records, not as current public support claims.

## Migration

- Make migrations idempotent where the hosting path allows it.
- Record counts and skipped rows for content or memory imports.
- Keep production mutation separate from local smoke tests and package generation.

Why This File Exists

This is a LLM Wiki memory file from aiwikis.org. It is shown here because AIWikis.org is demonstrating the real source files that make the UAIX / LLM Wiki memory system work, not only summarizing those systems after the fact.

Role

This file belongs to the source-side wiki layer. It preserves a focused concept, source proxy, graph record, or operating rule so the public site can cite reviewed conclusions without flattening every reason into a single long page.

Structure

The file is structured around these visible headings: MySQL Standard; Schema; Queries; Migration. Those headings are retrieval anchors: a crawler or LLM can decide whether the file is relevant before reading every line.

Prompt-Size And Retrieval Benefit

Keeping this material in a separate file reduces prompt pressure because an agent can load this exact unit only when its role, source site, category, or hash is relevant. The surrounding index pages point to it, while this page preserves the full content for audit and exact recall.

How To Use It

• Humans should read the metadata first, then inspect the raw content when they need exact wording or provenance.
• LLMs and agents should use the source site, category, hash, headings, and related files to decide whether this file belongs in the active prompt.
• Crawlers should treat the AIWikis page as transparent evidence and follow the source URL/source reference for authority boundaries.
• Future maintainers should regenerate this page whenever the source hash changes, then review the explanation if the role or structure changed.

Update Requirements

When this source file changes, update the raw source layer, normalized source layer, hash history, this rendered page, generated explanation, source-file inventory, changed-files report, and any source-section index that links to it.

Related Pages

• Source overview
• Site file index
• Site report index
• UAI system index
• Source provenance
• Site directory
• Organization reports

Provenance And History

• Current observation: 2026-06-22T01:56:21.9510185Z
• Source origin: current-source-workspace
• Retrieval method: local-source-workspace
• Duplicate group: sfg-693 (primary)
• Historical hash records are stored in data/hashes/source-file-history.jsonl.

Machine-Readable Metadata

{
    "title":  "Mysql Standard",
    "source_site":  "aiwikis.org",
    "source_url":  "https://aiwikis.org/",
    "canonical_url":  "https://aiwikis.org/aiwikis/files/wiki-global-coding-standards-mysql-md-92a134fe/",
    "source_reference":  "wiki/global/coding-standards/mysql.md",
    "file_type":  "md",
    "content_category":  "llm-wiki",
    "content_hash":  "sha256:92a134fee31328fc0eb59afc924616ff95afc08f32a895b9815a1580c6c8b020",
    "last_fetched":  "2026-06-22T01:56:21.9510185Z",
    "last_changed":  "2026-05-15T23:02:00.0545413Z",
    "import_status":  "unchanged",
    "duplicate_group_id":  "sfg-693",
    "duplicate_role":  "primary",
    "related_files":  [

                      ],
    "generated_explanation":  true,
    "explanation_last_generated":  "2026-06-22T01:56:21.9510185Z"
}