时间:2021-07-01 10:21:17 帮助过:18人阅读
load
load
- create database databaseName;
- create table tableName
- (
- id bigint,
- name_lee varchar(20),
- age_lee int,
- personNumber int
- )
load
load
- alter table tableName modify name_lee varchar(22);
- desc tableName;
load
- rename table tableName to NewTableName;
i‘m the delimiter/
- alter table test_lee change name_lee NewName VARCHAR(88);
change the column name;
-----------------------------------------------------
MySQL-8.0-Note
标签:技术 desc -- limit database table sql rename img