Bug #109100 Table Import Wizard includes table heading

• Submitted: 15 Nov 2022 16:20
• Modified: 17 Nov 2022 18:07
• Reporter: John King
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.30
• OS: Any
• CPU Architecture: Any
• Tags: import data

[15 Nov 2022 16:20] John King

Description:
Importing from a csv file with headers will also import the headers in the table.

How to repeat:
Create a table
CREATE TABLE `lb` (
  `lb_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vorname` varchar(255) DEFAULT NULL,
  `nachname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`lb_ID`)
) 

Import the attached csv file.

Show log reports five (5) tuples added not four:
Starting...
Prepare Import...
Prepare Import done
Import data file....
- Prepare Import
- Begin Import
- Data import
- Data import
- Data import
- Data import
- Data import
- Import finished
Import data file finished
Finished performing tasks.

Suggested fix:
Skip the first line

[15 Nov 2022 16:20] John King

Testdata

Attachment: Neue LB.csv (application/vnd.ms-excel, text), 80 bytes.

[16 Nov 2022 12:14] MySQL Verification Team

Hello John King,

Thank you for the bug report.
Imho, this is by design and not a bug. To avoid importing table headers, try to include all column names in csv file. Thanks.

Regards,
Ashwini Patil

[17 Nov 2022 18:07] John King

The table import wizard is supposed to ignore the first row for import. The Table impor wizard matches the first row header with the tuple attributes in the table