1、创建表格
CREATE TABLE tb_userlogin(
userid int(11) primary key auto_increment,
username varchar(50) not null,
password varchar(50) not null,
description text
);
2、增(插入)
INSERT INTO tb_userlogin(username, password, description) VALUES("abcdef", "123456", "login message");
3、删(删除)
DELETE * FROM tb_cardpasswdmsg WHERE username="abcdef"
4、查(查询)
SELECT * FROM tb_userlogin WHERE username = "abcdef" AND password = "123456"
5、改(更新)
UPDATE tb_userlogin SET password = "654321" WHERE username="abcdef"