Can you help me to explain, how to create Memory table with hashed index in MySQL?
Answer No: 188
MySQL provides USING clause which can be specified at table creation time to ask for hashed index on a particular column. The following example declares a hashed index on the username column:
CREATE TABLE users ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, username CHAR(15) NOT NULL, pwd CHAR(15) NOT NULL, INDEX USING HASH (username), PRIMARY KEY(id) ) Engine=MEMORY;
Comments
Add Comments
Found a bug? Or do you have a better solution for this? Feel free to leave a message: