01-08-2020 05:59 AM
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?
08-14-2020 03:01 AM
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