MySQL控制台实现数据库创建及表的增删查改

1.

创建查看数据库

create database gamedb;

show databases;

2.
创建查看表，查询，更新，删除表数据

use gamedb

create table users(id int auto_increment,username varchar(30),password varchar(30),primary key(id));

show tables;

select * from users;

update users  set password='789' where username='player2';

delete from users where id=3;

3.