Mysql And text file

[hussainz2000]

Hi all...
i have EXCEL File i save it as text file(tab dilimited) until i can change this text file to MySql table but when i run msdos prompot
and i wrote c:>cd mysql.then c:mysql>cd bin
then c:mysql\bin>mysql DatabaseName TableName < myfile.txt -u username -p password then i press enter
it give me the help menu , how can i do it plz..
step by step plz..
the OS is windows 2000
.. bye

[mithril]

Step 1. - Log into MySQL:

c:>mysql -u username -ppassword (note the absence of the space)

Step 2. - Load File into Table

mysql>LOAD DATA LOCAL INFILE 'c:/path/to/your/text_file.txt' INTO TABLE table_name;

This assumes that you have the table "table_name" already created in MySQL, if not you'll need to do that first. HTH.

-geoff

[hussainz2000]

1st: how can i know the username and password...
2nd:when i do step 2 it give me error message
Error 1046:no database selected
?????????!!!!!!!!help me plz

[mithril]

1. The username and password are the uername and password of any account which has at least INSERT privileges on the table you're dumping data into. If you haven't setup any accounts, you can use the default accounts created suring installation. They are:

&nbsp;&nbsp;username: root
&nbsp;&nbsp;password: &lt;empty string>

&nbsp;&nbsp;username: &lt;empty string>
&nbsp;&nbsp;password; &lt;empty string>

2. You must either first select the database which contains the table you're dumping into, or specify it in the LOAD DATA statement (I should've mentioned that🙂. Thus do either:

&nbsp;&nbsp;mysql>use &lt;your_db_name>;

and then the LOAD DATA statement or

&nbsp;&nbsp;mysql>LOAD DATA LOCAL INFILE 'c:/path/to/your/text_file.txt' INTO TABLE your_db_name.table_name;

I'd also suggest you seriously think about reading the MySQL manual at http://www.mysql.com/doc/ as this, and basically every other MySQL operation, are very well discussed in the docs.

-geoff