您的位置:首页 > 博客中心 > 数据库 >

MySQL-8.0-Note

时间:2022-03-15 15:05

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;

-----------------------------------------------------

技术图片

 

热门排行

今日推荐

热门手游