importing a data file - mysqlimport

I am having trouble trying to import a txt file. Can someone tell me what these errors are?

-> mysqlimport --delete -c employeeID quarter initials Q1 Q2 Q3 Q4 Q5 Q6 Q7
Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 --fields-enclosed-by=':' -u root evaluations C:\Documents and Settings\Ibo\Desktop\La1 784\cResp_imp.txt
ERROR:
Unknown command '\D'.
ERROR:
Unknown command '\I'.
ERROR:
Unknown command '\D'.
ERROR:

Dec 17 '07 #1

Subscribe Post Reply

2686

mwasif

802

Expert 512MB

Where you are executing the command? In shell or mysql prompt? Checkout MySQL Manual for complete details.

Dec 17 '07 #2

ibo3

I was doing it from the sql prompt. Know I have don it from the command prompt and I get a different error.

C:\Documents and Settings\Ibo>mysqlimport -c employeeID,quarter,initials,Q1,Q2,Q
3,Q4,Q5,Q6,Q7,Q8,Q9,Q10,Q11,Q12,Q13,Q14,Q15,Q16,Q1 7,Q18,Q19,Q20,Q21,Q22 --delete --fields-terminated-by=: -u root MyNorthwind "C:\Documents and Settings\Ibo\Desktop\evaluations.txt"

'mysqlimport' is not recognized as an internal or external command,
operable program or batch file.

Dec 18 '07 #3

Similar topics

importing a complete database

by: Oliver Spiesshofer | last post by:

Hi, I have a MySQL .sql file that contains not only a single table but several, its a dump from a complete database. How can I import that back into a MySQL Server? MySQLImport seems not to be...

MySQL Database

Importing headers

by: torjon | last post by:

I have a text file with 180 headers. Is it possible to import this file into mysql where mysql will automatically create the table with column headings from the headers (as sql server and access...

MySQL Database

loading data into a table from excel spreadsheet

by: Pindz | last post by:

Hello, I have a excel spreadsheet from which I would like to load data into a table in mysql. Can you please give me an example of the above. Thanks in advance Nagsy

MySQL Database

Importing Text Files

by: Joel | last post by:

Hi, I'm importing our DOS data base (Dataflex) to Mysql I have a table with 174,638 records that I convert into a tab delimetered Text file however, Mysql only reads 87,035! I checked the text...

MySQL Database

Importing data from Excel into PHP

by: Michal Maciejczak | last post by:

Is it possible to import data from excel file into php and than put it in mysql database?

PHP

parse URL (href) from xhtml, xhtml -> text, for data

by: hawat.thufir | last post by:

Given an xhtml file, how can I "export" the data to plain-text? That is, I want: google www.google.com Whereas, if I copy and paste what the browser shows, I lose the URL and end up with:...

.NET Framework

importing nonprintable delimiters with mysql ?

by: Jack | last post by:

Hi I was wondering if someone could reply with a command from the mysql client that I can issue which will import a flat file have 2 columns and a 034 octal (decimal 28, hex 1C) as the delimiting...

MySQL Database

Importing with phpMyAdmin

by: Toine | last post by:

Hello, I want to import a csv file into my table. However, I need to empty the table before I do this. The problem is, I only see an option to "replace" the data. Is there a way to empty a table...

MySQL Database

Importing MS Access into MySQL on Mac?

by: Vik Rubenfeld | last post by:

Is there a way to import an MS Access database .mdb file into MySQL running locally on a Mac? Thanks in advance to all for any info.

PHP

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General