创建一个多列索引:CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), INDEX name (last_name,first_...【阅读全文】
INSERT INTO doctor VALUES ("id","name1","password1");如何只添加某项信息也可只添加其中某项INSERT INTO doctor (name,password) VALUES ("name2","password2"); id为自增可以不用添加。其他信息必须为空。【阅读全文】