Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user' WHERE username='q' and password='123'' at line 1
代码如下
DROP TABLE IF EXISTS user
;
CREATE TABLE user
(id
int(10) NOT NULL AUTO_INCREMENT,username
varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,password
varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Records of user
INSERT INTO user
VALUES ('11', 'q', '123');
INSERT INTO user
VALUES ('10', '', '');