Rene Saarsoo

- [x] [CREATE TRIGGER](https://www.postgresql.org/docs/16/sql-createtrigger.html) - [x] `OR REPLACE` - [x] `CONSTRAINT` - [x] `BEFORE | AFTER | INSTEAD OF` - [x] `event [ OR ... ]` - [x] event types:...

- [x] [CREATE SCHEMA](https://www.postgresql.org/docs/16/sql-createschema.html) - [x] `IF NOT EXISTS` - [x] optional `schema_name` - [x] `AUTHORIZATION role_specification`: - [x] `user_name` - [x] `CURRENT_ROLE | CURRENT_USER | SESSION_USER` - [x] schema...

- [ ] [ALTER TABLE](https://dev.mysql.com/doc/refman/8.0/en/alter-table.html) - [x] `ADD [COLUMN] name definition` - [ ] `FIRST | AFTER col_name` - [ ] `ADD COLUMN (...)` - [ ] `ADD {INDEX |...

Summary ticket for overall implementation progress in MySQL. - [ ] #5 - [x] #54 - [ ] #55 - [ ] #56 - [ ] #59 - [ ]...

#### Prepared statements - [x] PREPARE - [x] EXECUTE - [x] basic syntax - [x] DEALLOCATE PREPARE ### Other DML statements - [ ] HANDLER - [ ] CALL -...

#### Data types - [ ] [Support of all data types](https://dev.mysql.com/doc/refman/8.0/en/data-types.html) #### Basic syntax - [ ] [comment syntax differences](https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-comments.html) - [x] [identifier syntax](https://dev.mysql.com/doc/refman/8.0/en/identifiers.html) - [x] unicode letters: `ähhää` -...

### Other - [ ] [ANALYZE](https://www.postgresql.org/docs/current/sql-analyze.html) - [x] plain `ANALYZE` - [x] multiple tables - [ ] optional columns lists - [ ] `VERBOSE` - [ ] options: - [...

- [ ] [CREATE TABLE](https://dev.mysql.com/doc/refman/8.0/en/create-table.html) - [x] `TEMPORARY` - [x] `IF NOT EXISTS` - [ ] column constraints: - [x] `NULL | NOT NULL` - [x] `DEFAULT { literal |...

Most of MariaDB syntax is the same as MySQL. This issue lists only the differences. #### Expressions - [x] No JSON operators (`->`, `->>`) - [x] No `MEMBER OF` operator...

#### Transactions - [ ] `START TRANSACTION` - [x] basic syntax - [ ] transaction characteristics - [x] `BEGIN [WORK]` - [ ] `COMMIT [WORK]` - [x] basic syntax -...