索引

create table user(
                    userid INT(10) PRIMARY KEY NOT NULL UNIQUE AUTO_INCREMENT,
                    username VARCHAR(20) NOT NULL ,
                    password VARCHAR(20) NOT NULL,
                    info TEXT,
                    UNIQUE INDEX index_uid(userid DESC),
                    INDEX index_user(username, password),
                    FULLTEXT INDEX index_info(info)
                    )ENGINE=MyISAM;
                    
create table information(
                            id INT(10) PRIMARY KEY NOT NULL UNIQUE AUTO_INCREMENT,
                            name VARCHAR(20) NOT NULL,
                            sex VARCHAR(40) NOT NULL,
                            birthday DATE,
                            address VARCHAR(50),
                            tel VARCHAR(20),
                            pic BLOB
                        );
                        
create index index_name on information(name(10));
create index index_bir on information(birthday, address);
alter table information add unique index index_id(id ASC);