In what context is the MySQL "one" keyword used?

Question

I noticed that the word 'one' is in the list of keywords for MySQL. I do not remember to see any request that uses 'one' . I searched here and google, but I did not find anything about it. Does anyone have an example of when this keyword will be used?

Answer 1

I found a couple of places in guide 5.7:

• XA Transactions for InnoDB 14.3.7.1

  XA COMMIT xid [ONE PHASE]

• For a SHOW EVENTS FROM table query ( 14.7.5.18 ), the Type result field may be ONE TIME

   mysql> SHOW EVENTS\G *************************** 1. row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: ONE TIME Execute at: NULL Interval value: 10 Interval field: SECOND Starts: 2006-02-09 10:41:23 Ends: NULL Status: ENABLED Originator: 0 character_set_client: latin1 collation_connection: latin1_swedish_ci Database Collation: latin1_swedish_ci