Re: Problem with mysqlimport

2003-12-10 Thread Pawe Filutowski
--local is a valid option for mysqlimport in 3.23.49 according to the manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport) What is the entire command you are using? Hi, My command is: mysqlimport -p -L ilk gwarancje.txt And I get error: mysqlimport: Error: The used

Problem with mysqlimport

2003-12-09 Thread Pawe Filutowski
I tryed to import from text file (columns divided by tabulators) like this: 5724KF2003CSDEUROPAPARKAN2003-12-12MarcinTamkanono . . . On PHPTriad (under Windows 2000) it works perfectly ! I use command: mysqlimport database file.txt But under Linux (RedHat) i

Re: Problem with mysqlimport

2003-12-09 Thread Pawe Filutowski
' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:11 PM Subject: RE: Problem with mysqlimport If the the file is on the same machine as your shell is running, specify --local when running mysqlimport. Matt -Original Message- From: Pawe Filutowski [mailto

How to get two columns from different tables

2003-11-06 Thread Pawe Filutowski
Hello, I`m a newer reader. I have problem with query. There are two tables: tab1: id | test1 0 | string1 1 | string2 2 | string3 and tab2: id | test1 0 | string1 1 | string2 2 | string3 I want to get columns test1 (from tab1) and test2 where id.tab1 = id.tab2 but i

Re: How to get two columns from different tables

2003-11-06 Thread Pawe Filutowski
query about id=0. And I`m looking for answer such: 0,NULL about id=6: NULL, 6 Do you have any idea ?? Best regards - Paul - Original Message - From: [EMAIL PROTECTED] To: Pawe Filutowski [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:43 PM Subject