如何在MySQL中将自动增量格式设置为0001？

CREATE TABLE my_table (
  id INT(4) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

INSERT INTO my_table (name) VALUES ('John Doe');
INSERT INTO my_table (name) VALUES ('Jane Smith');

SELECT * FROM my_table;

+-------+-----------+
| id    | name      |
+-------+-----------+
| 0001  | John Doe  |
| 0002  | Jane Smith|
+-------+-----------+