· 5 years ago · Jun 15, 2020, 05:30 AM
1create database if not exists STT;
2
3create user 'STT'@'%' identified by 'STT';
4
5grant all privileges on *.* to 'STT'@'%';
6flush privileges;
7
8set global sql_mode = '';
9
10CREATE TABLE users(
11 id INT(16) NOT NULL,
12 wallet DECIMAL(13, 2) NOT NULL
13);
14
15drop table users;
16
17insert into users (id, wallet ) values (101, 500.5)
18insert into users (id, wallet ) values (202, 50.10)
19
20SELECT * FROM users
21
22UPDATE users SET wallet = 20 WHERE id = 202