点击查看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)
登录查询密码 select * from user where username="b";