Hi, I am having problems loading data into a table and have 2 questions. 1) I want to load some data from a text file in to a table by using the following line: LOAD DATA LOCAL INTO "st.txt" INTO TABLE studio;
this keeps giving me : File "st.txt" not found (ErrorCode: 2) Where should I store the st.txt file. I am using Windows and have mysql stored at c:\mysql. I have tried putting the file in the following locations: C:\mysql, C:\mysql\data, and C:\mysql\data\[DATABASE NAME](where the tables are stored) But keep getting the error. 2) The table I want to load the data in to is as follows: create table studio ( studio_id smallint unsigned not null auto_increment, studio_name varchar(50) not null, primary key(studio_id) ); I know I have to create the txt file row by row but do I enter studio_id. I do not think I have to as it should be automatic as it is auto increment. I have three records I want to put in to the file and have done it as follows: Branbury Daventry Stockport OR should it be(the space represents a TAB) 1 Branbury 2 Daventry 3 Stockport There is an example in the mysql manual but it does not use auto_increment variables. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
