1. Create a data table based on sql.
2. Steps to insert data
< img alt="Use Navicat Premium to import excel data for Mysql" src="/wp-content/uploads/images/database/mysql/1626816522022.png" >
3. Error message
stron g>
1.Data too long for column’ccs_login_name’ at row 1
Modify the character length of ccs_login_name
alter table test_20190925 modify column ccs_login_name varchar(50) ;
2. How to modify the column names in the table
Format: ALTER TABLE table name CHANGE old attribute name new attribute name new data type;
3. How to Modify engine
SHOW CREATE TABLE student2; #View the current engine ALTER TABLE table name ENGINE = storage engine name;