Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Do they have way can import CSV which has blank header(column name)?

K13483's profile image K13483 posted 2 months ago in General Permalink

My csv has some blank header like picture Do it have way can import?

1 attachment(s):
  • 2022-10-14-09_51_33-metabaserecord-PowerPoint
ansgar's profile image ansgar posted 2 months ago Permalink

Then you have to give it a name, in the CREATE code, before click on "Ok, create table".

K13483's profile image K13483 posted 2 months ago Permalink

@ansgar,sorry~have another stupid question I want to increase a column when create table,and give default values I write query like picture,but it's value still empty,I have a wrong?

1 attachment(s):
  • 1232022-10-14-13_37_23-metabaserecord-PowerPoint
ansgar's profile image ansgar posted 2 months ago Permalink

After auto-creating the table and importing rows, you can still edit the table definition. Just click on the "Table: xyz" tab to see/edit the column definitions:

Description

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.