Shulou(Shulou.com)06/02 Report--

1. Create a data table based on sql.

two。 Insert data step

3. Error prompt

1.Data too long for column 'ccs_login_name' at row 1

Modify ccs_login_name character length

Alter table test_20190925 modify column ccs_login_name varchar (50)

two。 How to modify column names in a table

Format: ALTER TABLE table name CHANGE old attribute name new attribute name new data type

3. How to modify the engine

SHOW CREATE TABLE student2; # View current engine

ALTER TABLE table name ENGINE = storage engine name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.