mysql

# 显示数据库
show databases;
# 删除银行数据库
drop database if exists bankinfo;
# 创建银行数据库
create database if not exists bankinfo;
# 使用银行数据库
use bankinfo;
# 创建账户表
CREATE TABLE if not exists bankinfo.accountinfo(                     
             id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,             
             userName varchar(20) NOT NULL,                   
             phoneNumber varchar(11) NOT NULL,                       
             cardID varchar(11) NOT NULL,                       
             userID int(18) NOT NULL,
             loginPassword varchar(11)
           )engine=innodb auto_increment=1 default charset=utf8;
# 删除表
drop table if exists accountinfo;
# 显示账户表
show create table accountinfo;
# 选择银行数据库的账户表
select *from bankinfo.accountinfo;
# 插入数据，增加数据insert
INSERT INTO `bankinfo`.`accountinfo` (userName, phoneNumber, cardID, userID, loginPassword)  VALUES ('xxx', '111', '222', '333', '123456');
# 查找数据selcet
select * from `bankinfo`.`accountinfo` where userName='eee';
# 删除数据delete
delete from `bankinfo`.`accountinfo` where userName='www';
# 修改更新数据 update
update `bankinfo`.`accountinfo` set `loginPassword` = '123456' where `userName` = '333';

# *******************不加where约束条件会清空表里所有数据， 使用该语句时谨慎操作***************************
DELETE FROM `bankinfo`.`accountinfo`;