topic simplified table auditing configuration options in mysql? in Integration and Testing

simplified table auditing configuration options in mysql?

MarcoCole — Wed, 08 Jan 2020 13:59:25 GMT

I'm creating my first MySQL database although I have 10+ years in SQL Server. I think SS has an auditing option which will automatically record the history of all row changes. I'd rather not add the following columns to my MySQL tables b/c this is data which can be inferred, and therefore should be imho:

CreatedBy CreatedDate UpdatedBy UpdatedDate

What are my options for configuring SS to infer the column values listed above?

Re: simplified table auditing configuration options in mysql?

getlines — Fri, 27 Mar 2020 23:53:05 GMT

I think SS has an auditing option which will automatically record the history of all row changes.

https://get-lines.com/

Re: simplified table auditing configuration options in mysql?

chinachin — Wed, 20 May 2020 03:08:43 GMT

Your sharing is very helpful word counter

Re: simplified table auditing configuration options in mysql?

pestworld — Wed, 03 Jun 2020 17:45:59 GMT

MySQL auditing configuration options available?

Kittenfoods

Re: simplified table auditing configuration options in mysql?

kiel46 — Fri, 14 Aug 2020 10:01:19 GMT

Data types seem confusing, for example, if the field's data type is Text, the field can store the data, consisting of text or numeric characters. However, fields with data type Number will only be able to store numeric data. Therefore, you must know what types of properties are used with each data type. 2player games

Re: simplified table auditing configuration options in mysql?

unicornaz — Mon, 07 Dec 2020 08:29:48 GMT

i think you must know what types of properties are used with each data type, Must have a clear view of unicorn coloring pages

Re: simplified table auditing configuration options in mysql?

worldclipat — Mon, 03 May 2021 01:46:55 GMT

I have the same errors with my sites: https://game37.net and https://gpng.net

Re: simplified table auditing configuration options in mysql?

kimchiimg — Tue, 08 Jun 2021 16:21:25 GMT

I'm so excited and looking forward to it

resize image

Re: simplified table auditing configuration options in mysql?

hariesunza — Sun, 28 Sep 2025 08:21:10 GMT

MySQL does **not** have built-in automatic auditing like SQL Server. Your main options are:

1. **Triggers** – Create `BEFORE INSERT` / `BEFORE UPDATE` triggers to log changes into an audit table.

2. **Audit Plugins** – Use MySQL Enterprise Audit (paid) or free alternatives like `McAfee MySQL Audit Plugin`.

3. **Binary Logs** – Enable binlogs for row-based replication, then parse them for change history.

4. **Application Layer** – Let your app write `CreatedBy/UpdatedBy` and timestamps automatically.

Re: simplified table auditing configuration options in mysql?

halfsweetlemon — Mon, 23 Mar 2026 06:19:04 GMT

Helpful post. As someone with a SQL Server background, I also wondered about the best MySQL approach for auditing created and updated fields.

photo resizer now