How to import csv to MySQL? (Mysql, HeidiSQL)

pemoch's profile image pemoch posted 2 years ago in General Permalink

Как импортировать csv?
HeidiSQL 11.3.0.6295(64)

CREATE TABLEprisoners(idINT(11) NOT NULL AUTO_INCREMENT,first_nameCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',last_nameCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',middle_nameCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',fioVARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',descriptionTEXT NULL DEFAULT NULL COLLATE 'utf8_unicode_ci', PRIMARY KEY (id) USING BTREE ) COLLATE='latin1_swedish_ci' ENGINE=MyISAM ROW_FORMAT=DYNAMIC AUTO_INCREMENT=5 ;

3 attachment(s):
  • 24.08.2022_08-57-45
  • 24.08.2022_08-59-08
  • 24.08.2022_09-00-02
ansgar's profile image ansgar posted 2 years ago Permalink

Please post in english.

I already replied to this "file not found" question in your earlier thread.

Please login to leave a reply, or register at first.