4.1 配置Mysql与注册登录模块(上)

发布时间 2023-12-04 20:47:31作者: E/Y/E

image


点击查看sql代码
 create database kob;
 use kob;
  create table user(id int,username varchar(100),password varchar(100));
mysql> show tables;
+---------------+
| Tables_in_kob |
+---------------+
| user          |
+---------------+
1 row in set (0.00 sec)
 insert into user value(1,'yxc','pyxc');
Query OK, 1 row affected (0.02 sec)
mysql> insert into user values(2,'c','pc');
Query OK, 1 row affected (0.00 sec)

mysql> select * from user where username='c';
+------+----------+----------+
| id   | username | password |
+------+----------+----------+
|    2 | c        | pc       |
+------+----------+----------+
1 row in set (0.00 sec)
用户新建用户insert into user value(2,'b','pb');

登录查询密码 select * from user where username="b";