当前位置:Gxlcms > 数据库问题 > MySQL-8.0-Note

MySQL-8.0-Note

时间:2021-07-01 10:21:17 帮助过:18人阅读

load

 

 

 

load

  1. create database databaseName;
  2. create table tableName
  3. (
  4. id bigint,
  5. name_lee varchar(20),
  6. age_lee int,
  7. personNumber int
  8. )

  load

 

 

load

  1. alter table tableName modify name_lee varchar(22);
  2. desc tableName;

  load

  1. rename table tableName to NewTableName;

  i‘m the delimiter/

  1. 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   

人气教程排行