Tjyylli

What is a DAG (Graph Theory)?

What happens when I Twin Life Transference?

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

Premature ending of generator in list comprehension

Why zero tolerance on nudity in space?

Explanation of a regular pattern only occuring for prime numbers

Why is it that Bernie Sanders is always called a "socialist"?

How to politely refuse in-office gym instructor for steroids and protein

Plausible reason for gold-digging ant

Has Britain negotiated with any other countries outside the EU in preparation for the exit?

Why does magnet wire need to be insulated?

Is there a defined priority for pattern matching?

Has any human ever had the choice to leave Earth permanently?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Count repetitions of an array

How to access internet and run apt-get through a middle server?

Why do we have to make "peinlich" start with a capital letter and also end with -s in this sentence?

Why is Agricola named as such?

Can you tell from a blurry photo if focus was too close or too far?

Early credit roll before the end of the film

Cat is tipping over bed-side lamps during the night

Can 5 Aarakocra PCs summon an Air Elemental?

How to deal with possible delayed baggage?

Eww, those bytes are gross

Can I automatically create a table in mySQL from a csv file with headers as column names?

Export spreadsheet and import as table into mysqlHow can I import a CSV file into an SQLite table that doesn't allow null values?User Friendly CSV to MSSQL import with column matchSpreadsheet to MySQLExcel - Find a specific column in a CSV file, and copy to the current sheetHow to automatically import data from csv file and append to existing Excel tableError when importing .xslx/.csv file to MySQL database.csv file from Excel vs .csv file from Libre Officeload csv file into mysql using batch?“character encoding hell”- Configuring mariadb for utf8 end to end

0

I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually create a table with a column for each column in the CSV file. Is there any way to automatically create this table based on the headers in the CSV file?

here below is the query for to load csv into mysql table t1 in which t1 is already created in database manually

load data local infile "C:\EQA\project\input1.csv" 

    into table request_table 

    character set latin1 

    fields terminated by','

    ENCLOSED BY '"'

    lines terminated by'rn' 

    IGNORE 1 ROWS

but i am actually looking to generate table based on csv headers is that possible?
here my requirement is evertime when i export some data from other database like oracle i a able to store it into csv now i need to import this csv into other database like mysql if it is for one time we can do manually to create table in mysql what if i get many csv files from oracle databse? if i follow manually creating table it leads more complexity right!is ther any better case available if so can u please help me

batch-file mysql csv sql-server

share|improve this question

edited 5 mins ago

seepana avinash

asked Feb 23 at 6:15

seepana avinashseepana avinash

424

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I would comment that what you are calling a script is actually a query - a script is a set of commands which I surmise would create additional queries which would create the table first. This is definately technically doable, but I don't do Windows, and prefer Postgres to MySQL, so can't be of much assistance on exactly how its done.
  
  – davidgo
  Feb 23 at 9:54
  

  
  
  
  

add a comment | 

0

I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually create a table with a column for each column in the CSV file. Is there any way to automatically create this table based on the headers in the CSV file?

here below is the query for to load csv into mysql table t1 in which t1 is already created in database manually

load data local infile "C:\EQA\project\input1.csv" 

    into table request_table 

    character set latin1 

    fields terminated by','

    ENCLOSED BY '"'

    lines terminated by'rn' 

    IGNORE 1 ROWS

but i am actually looking to generate table based on csv headers is that possible?
here my requirement is evertime when i export some data from other database like oracle i a able to store it into csv now i need to import this csv into other database like mysql if it is for one time we can do manually to create table in mysql what if i get many csv files from oracle databse? if i follow manually creating table it leads more complexity right!is ther any better case available if so can u please help me

batch-file mysql csv sql-server

share|improve this question

edited 5 mins ago

seepana avinash

asked Feb 23 at 6:15

seepana avinashseepana avinash

424

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I would comment that what you are calling a script is actually a query - a script is a set of commands which I surmise would create additional queries which would create the table first. This is definately technically doable, but I don't do Windows, and prefer Postgres to MySQL, so can't be of much assistance on exactly how its done.
  
  – davidgo
  Feb 23 at 9:54
  

  
  
  
  

add a comment | 

I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually create a table with a column for each column in the CSV file. Is there any way to automatically create this table based on the headers in the CSV file?

here below is the query for to load csv into mysql table t1 in which t1 is already created in database manually

load data local infile "C:\EQA\project\input1.csv" 

    into table request_table 

    character set latin1 

    fields terminated by','

    ENCLOSED BY '"'

    lines terminated by'rn' 

    IGNORE 1 ROWS

but i am actually looking to generate table based on csv headers is that possible?
here my requirement is evertime when i export some data from other database like oracle i a able to store it into csv now i need to import this csv into other database like mysql if it is for one time we can do manually to create table in mysql what if i get many csv files from oracle databse? if i follow manually creating table it leads more complexity right!is ther any better case available if so can u please help me

batch-file mysql csv sql-server

share|improve this question

edited 5 mins ago

seepana avinash

asked Feb 23 at 6:15

seepana avinashseepana avinash

424

load data local infile "C:\EQA\project\input1.csv" 

    into table request_table 

    character set latin1 

    fields terminated by','

    ENCLOSED BY '"'

    lines terminated by'rn' 

    IGNORE 1 ROWS

share|improve this question

edited 5 mins ago

seepana avinash

asked Feb 23 at 6:15

seepana avinashseepana avinash

424

share|improve this question

edited 5 mins ago

seepana avinash

asked Feb 23 at 6:15

seepana avinashseepana avinash

424

asked Feb 23 at 6:15

seepana avinashseepana avinash

424

asked Feb 23 at 6:15

seepana avinashseepana avinash

424