Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how to Import a file.csv with only the odd rows into MySQL. //this line add all the 1000 records that the file contains into my

how to Import a file.csv with only the odd rows into MySQL.

//this line add all the 1000 records that the file contains into my table called "users" but I want to add only ODD lines from the file.

LOAD DATA LOCAL INFILE '/root/users.csv' INTO TABLE users FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY ' '

how do I do that so it only gets the ODD rows that are in the file?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Database Programming

Authors: Chris Fehily

1st Edition

1937842312, 978-1937842314

More Books

Students also viewed these Databases questions

Question

3. Describe the communicative power of group affiliations

Answered: 1 week ago