Import Excel data for mysql using Navicat Premium

1. Create a data table based on sql.

2. Steps to insert data

Use Navicat Premium to import excel data for Mysql
Use Navicat Premium to import excel data for Mysql
Use Navicat Premium to import excel data for Mysql
Use Navicat Premium to import excel data for Mysql
Use Navicat Premium to import excel data for Mysql
Use Navicat Premium to import excel data for Mysql
Use Navicat Premium to import excel data for Mysql
< 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;

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 2992 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.