Files

800 B

MySQL

  • Use MySQL syntax and behavior only for data sources whose declared engine is mysql.
  • Preserve the configured version, schema, character set, collation, time zone, naming, migration, and access conventions.
  • Parameterize values. Do not build SQL by concatenating untrusted input.
  • Consider indexes and execution plans for changed filters, joins, ordering, grouping, and pagination without guessing from small data sets.
  • Preserve transaction, locking, null, date/time, decimal, and generated-key semantics.
  • Do not introduce MSSQL or other dialect syntax into MySQL paths.
  • A source-code change approval authorizes SQL analysis and migration drafting only. Execute DDL, DML, procedures, or migrations only with separate explicit approval and the declared data-source access level.