SQL statements are used to modify, add, delete, and modify attributes (MySql) and sqlmysql

SQL statements are used to modify, add, delete, and modify attributes (MySql) and sqlmysql

Method 1:

Directly (manually) modify the database name, database table name, database column name, and column attribute

 

Method 2:

Use SQL statements to modify

-- Alter table tableName RENAME newTableName;

-- Adds the COLUMN name alter table tableName add column columnName VARCHAR (10 );

-- Delete the alter table tableName drop column columnName;

-- Modify the COLUMN name. The length of the COLUMN is alter table tableName change column oldColumnName newColumnName VARCHAR (200 );

-- Case sensitive: alter table tableName MODIFY columnName VARCHAR (50) collate gbk_bin;