using twitter snowflake on mysql function. it's create global auto increment table to provide database level id generator.
notice: the generator function used mysql REPLACE INTO statement, so you can't be use AUTO_INCREMENT on other tables.
- if you want use your own epoch day. you can change the function variable of epoch,find it at gen_ticket64.sql.
- when you have multiple databases to want using it, you must be change the function variable of node on each database.find it at gen_ticket64.sql.
- execute tb_tickets.sql first to create global auto increment table, then execute gen_ticket64.sql to create the mysql function.
- use
SELECT gen_ticket64()statement get id.