portal项目本地mysql操作

[yangbo5207]

1. 登录

~ mysql -u root -p
// 密码为空

1. 查看数据库

~ use databases;

1. 选中名为stock_localhost的数据库

~ use stock_localhost;

1. 根据自己的测试账号信息查询对应的数据

~ select * from user where real_name = '阳波';

1. 修改某一个字段的值 如 pid

~ update user set pid = 144701 where phone = '14900000086';

~ update user set first_saving_time = '2016-11-01 00:00:00', is_depost=3000 where phone = '14900000086';

~ update user set deposit_time = 1477453038000, is_deposit=3000 where phone = '14900000086';

1. 查询某些字段的值

~ select first_saving_time, pid, id, real_name from user where phone = '14900000086';