I design a database on Mysql , one of the tables is call 'account' which contains user related information like username, email address etc.
Due to large amount of user data running in millions of record, I have decided to partition the account table. The first partition should contain username starting with A - G, second partition H - O and the last partition from P - Z.

Also, I plan to index with username field
Please help me with the query for table creation and inserting data on the table.

Thx in adv.