Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from userG
- *************************** 1. row ***************************
- id: 1
- username: crm
- password: AAER8]HR6UnR4knR4YnRnN[]
- accountNonExpired:
- accountNonLocked:
- credentialsNonExpired:
- enabled:
- created: 2017-03-12 17:40:25
- createdUser: system
- lastUpdated: NULL
- lastUpdatedUser: NULL
- visible:
- deleted:
- deletedUser: NULL
- 1 row in set (0.00 sec)
- mysql> update user set username = 'test' where id = 1;
- Query OK, 1 row affected (0.00 sec)
- Rows matched: 1 Changed: 1 Warnings: 0
- mysql> select * from userG
- *************************** 1. row ***************************
- id: 1
- username: test
- password: AAER8]HR6UnR4knR4YnRnN[]
- accountNonExpired:
- accountNonLocked:
- credentialsNonExpired:
- enabled:
- created: 2017-03-12 17:40:25
- createdUser: system
- lastUpdated: NULL
- lastUpdatedUser: NULL
- visible:
- deleted:
- deletedUser: NULL
- 1 row in set (0.00 sec)
- mysql> update user set visible = true where id = 1;
- Query OK, 0 rows affected (0.00 sec)
- Rows matched: 1 Changed: 0 Warnings: 0
- mysql> select * from userG
- *************************** 1. row ***************************
- id: 1
- username: test
- password: AAER8]HR6UnR4knR4YnRnN[]
- accountNonExpired:
- accountNonLocked:
- credentialsNonExpired:
- enabled:
- created: 2017-03-12 17:40:25
- createdUser: system
- lastUpdated: NULL
- lastUpdatedUser: NULL
- visible:
- deleted:
- deletedUser: NULL
- 1 row in set (0.00 sec)
- mysql> show create table user;
- +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Table | Create Table |
- +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | user | CREATE TABLE `user` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` varchar(50) NOT NULL,
- `password` varchar(150) NOT NULL,
- `accountNonExpired` bit(1) DEFAULT b'1',
- `accountNonLocked` bit(1) DEFAULT b'1',
- `credentialsNonExpired` bit(1) DEFAULT b'1',
- `enabled` bit(1) DEFAULT b'0',
- `created` datetime NOT NULL,
- `createdUser` varchar(50) NOT NULL,
- `lastUpdated` datetime DEFAULT NULL,
- `lastUpdatedUser` varchar(50) DEFAULT NULL,
- `visible` bit(1) DEFAULT b'0',
- `deleted` bit(1) DEFAULT b'0',
- `deletedUser` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
- +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set (0.00 sec)
- mysql> select version();
- +-------------------------+
- | version() |
- +-------------------------+
- | 5.7.17-0ubuntu0.16.04.1 |
- +-------------------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement