auto_partition_name

description

Syntax

VARCHAR AUTO_PARTITION_NAME('RANGE', 'VARCHAR unit', DATETIME datetime)

VARCHAR AUTO_PARTITION_NAME('LIST', VARCHAR,...)

Generate datetime partition names by unit following RANGE’s partition name rules

Convert strings to partition names following LIST’s partition name rules

The datetime parameter is a legal date expression.

The unit parameter is the time interval you want, the available values are: [second, minute, hour, day, month, year]. If unit does not match one of these options, a syntax error will be returned.

example

  1. mysql> select auto_partition_name('range', 'years', '123');
  2. ERROR 1105 (HY000): errCode = 2, detailMessage = range auto_partition_name must accept year|month|day|hour|minute|second for 2nd argument
  4. mysql> select auto_partition_name('range', 'year', '2022-12-12 19:20:30');
  5. +---------------------------------------------------------------+
  6. | auto_partition_name('range', 'year', '2022-12-12 19:20:30')   |
  7. +---------------------------------------------------------------+
  8. | p20220101000000                                               |
  9. +---------------------------------------------------------------+
  11. mysql> select auto_partition_name('range', 'month', '2022-12-12 19:20:30');
  12. +---------------------------------------------------------------+
  13. | auto_partition_name('range', 'month', '2022-12-12 19:20:30')  |
  14. +---------------------------------------------------------------+
  15. | p20221201000000                                               |
  16. +---------------------------------------------------------------+
  18. mysql> select auto_partition_name('range', 'day', '2022-12-12 19:20:30');
  19. +---------------------------------------------------------------+
  20. | auto_partition_name('range', 'day', '2022-12-12 19:20:30')    |
  21. +---------------------------------------------------------------+
  22. | p20221212000000                                               |
  23. +---------------------------------------------------------------+
  25. mysql> select auto_partition_name('range', 'hour', '2022-12-12 19:20:30');
  26. +---------------------------------------------------------------+
  27. | auto_partition_name('range', 'hour', '2022-12-12 19:20:30')   |
  28. +---------------------------------------------------------------+
  29. | p20221212190000                                               |
  30. +---------------------------------------------------------------+
  32. mysql> select auto_partition_name('range', 'minute', '2022-12-12 19:20:30');
  33. +---------------------------------------------------------------+
  34. | auto_partition_name('range', 'minute', '2022-12-12 19:20:30') |
  35. +---------------------------------------------------------------+
  36. | p20221212192000                                               |
  37. +---------------------------------------------------------------+
  39. mysql> select auto_partition_name('range', 'second', '2022-12-12 19:20:30');
  40. +---------------------------------------------------------------+
  41. | auto_partition_name('range', 'second', '2022-12-12 19:20:30') |
  42. +---------------------------------------------------------------+
  43. | p20221212192030                                               |
  44. +---------------------------------------------------------------+
  46. mysql> select auto_partition_name('list', 'helloworld');
  47. +-------------------------------------------+
  48. | auto_partition_name('list', 'helloworld') |
  49. +-------------------------------------------+
  50. | phelloworld10                             |
  51. +-------------------------------------------+
  53. mysql> select auto_partition_name('list', 'hello', 'world');
  54. +-----------------------------------------------+
  55. | auto_partition_name('list', 'hello', 'world') |
  56. +-----------------------------------------------+
  57. | phello5world5                                 |
  58. +-----------------------------------------------+
  60. mysql> select auto_partition_name('list', "你好");
  61. +------------------------------------+
  62. | auto_partition_name('list', "你好") |
  63. +------------------------------------+
  64. | p4f60597d2                         |
  65. +------------------------------------+

keywords

  1. AUTO_PARTITION_NAME,AUTO,PARTITION,NAME