Hi All,
Tearing my hair out with this one! I am trying to load data from a text file
from the command line, this is the syntax...
LOAD DATA INFILE 'users_1.csv' INTO TABLE 'ma0133' FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';
The error I get
Resolved, used this syntax...
LOAD DATA INFILE '/path/from/root/to/file.csv' INTO TABLE ma0133 FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES
TERMINATED BY '\r\n'
- Phil.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
Hi All,
I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time
seemed to actually got somewhere! however, my existing PHP scripts failed to
connect to localhost as the password has not been set after the install. I
ran the following command (obviously seriously misunderstood
Hi All,
I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com),
which is something I have done on numerous occasions without problem.
However, this RaQ for some reason does not have /tmp/mysql.sock installed
when the package is installed. When I uninstall the pkg, the script
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP addresses on the server. I am assuming that localhost is the problem,
how can I manually change localhost to be an IP address?
The error message is:
Warning: mysql_connect(): Can't connect to local MySQL
Could not read response from last sender :o(
-Original Message-
From: Phil Ewington - 43 Plc [mailto:[EMAIL PROTECTED]
Sent: 01 September 2003 11:35
To: Mysql
Subject: Cannot Connect to Server
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP
Hi All,
I am trying to use a function as a default value for a column but do not
seem to get the desired result. I want to use the NOW() function for a
last_updated column, here is my code...
CREATE TABLE test_table (
last_updated datetime NOT NULL default `NOW()`
) TYPE=MyISAM;
This gives an
No functions as default values is a bummer, but timestamp will do he trick,
so thanks for your help; much appreciated.
Phil.
-Original Message-
From: Cybot [mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 15:37
To: [EMAIL PROTECTED]
Subject: Re: Functions as default values
I am trying
