Bibles

tech2022-07-30  159

load data infile ‘D:/lianhanghao.csv’ into table lianhanghao_empty fields terminated by ‘,’ optionally enclosed by ‘"’ escaped by '"'lines terminated by ‘\r\n’;

create table lianhanghao_empty( code VARCHAR(10), bankno int, bankname VARCHAR(10), areacode int, province VARCHAR(10), city VARCHAR(10), clearcode int )

alter table lianhanghao_empty change bankno bankno VARCHAR(100); alter table lianhanghao_empty change areacode areacode VARCHAR(100); alter table lianhanghao_empty change clearcode clearcode VARCHAR(100); alter table lianhanghao_empty change bankname bankname VARCHAR(100); alter table lianhanghao_empty change city city VARCHAR(1000); alter table lianhanghao_empty change code code VARCHAR(1000);

select * from lianhanghao;

select database(); show tables;

drop table lianhanghao_empty;

SHOW FULL COLUMNS FROM lianhanghao;

MySQL库改名、表改名 数据库中的库或表在开发环境下可能需要改名,关于MySQL的改名步骤如下:

1、备份数据库,备份后就可以安心的去改名了,如果操作错误还可以及时恢复

mysqldump -R -uroot -p 数据库名称> xxx.sql

2、表改名

rename table database.oldtable to database.newtable

例子:

rename table house.record to house.bookrecord;

3、库改名

create database newdatabase;

rename table olddatabase.table1 to newdatabase.table1;

rename table olddatabase.table2 to newdatabase.table2;

rename table olddatabase.table3 to newdatabase.table3;

drop database olddatabase;

4、检查是否改名成功,可以查看一下对应库下的表以及表中的部分内容

例子:

create database newhouse;

rename table house.admin TO newhouse.admin;

rename table house.confirm TO newhouse.confirm;

rename table house.contacts TO newhouse.contact;

rename table house.record to newhouse.bookrecord;

drop database hosue;

rename table sheet to shibor201912_tbl;

select * from shibor201912_tbl;

最新回复(0)