MySQL-8.0-Note

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