操作数据库 mysql
创建表
增删改查
insert into users(username,`password`,realname) values('zhangsan','123','张三');
select * from users;
select id,username from users;
select id,username from users where state<>'0'; // 不等于0
select id,username from users where username='zhangsan';
select id,username from users where username='zhangsan' and `password`='123';
select id,username from users where username like '%zhang%';
select id,username from users where username like '%zhang%' order by id desc;
update users set realname='lisi'; -- 所有行
update users set realname='lisi2' where username='lisi';
delete from users where username='lisi';
select version(); -- 查看版本
Nodejs 操作数据库
执行
node index.js
