mysql数据库建立触发器，做历史记录查询
mysql触发器
大家好，我现在想做历史查询，把历史的记录保存然后做历史查询，要建立一个历史变，然后在原表上加入触发器，请问触发器语句怎么写，我是要将原表的所有字段，不管是修改还是没修改的的记录都存入历史变，因为要做历史查询，请问历史表的字段怎么设置，建立触发器，怎么写定义语句，我用的是navicat，说的具体点，新手学习，好多不懂，如果能加个qq咨询就更好了……
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Reduce the use of MySQL memory in Docker
Mar 04, 2025 pm 03:52 PM
Reduce the use of MySQL memory in Docker
How do you alter a table in MySQL using the ALTER TABLE statement?
Mar 19, 2025 pm 03:51 PM
How do you alter a table in MySQL using the ALTER TABLE statement?
How to solve the problem of mysql cannot open shared library
Mar 04, 2025 pm 04:01 PM
How to solve the problem of mysql cannot open shared library
Run MySQl in Linux (with/without podman container with phpmyadmin)
Mar 04, 2025 pm 03:54 PM
Run MySQl in Linux (with/without podman container with phpmyadmin)
What is SQLite? Comprehensive overview
Mar 04, 2025 pm 03:55 PM
What is SQLite? Comprehensive overview
Running multiple MySQL versions on MacOS: A step-by-step guide
Mar 04, 2025 pm 03:49 PM
Running multiple MySQL versions on MacOS: A step-by-step guide
What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?
Mar 21, 2025 pm 06:28 PM
What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?
How do I configure SSL/TLS encryption for MySQL connections?
Mar 18, 2025 pm 12:01 PM
How do I configure SSL/TLS encryption for MySQL connections?
