Le Saturday 17 December 2005 04:54, Karl Krelove(Karl Krelove
[EMAIL PROTECTED]) disait:
Hello,
LOAD DATA INFILE 'home/karl/Student_List.csv' into table
^^^
student_list FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES
TERMINATED BY '\n';
In response I get: ERROR 13
Karl Krelove wrote:
I'm trying to import a large amount of data from an Access database containing
information about 9,000+ students in a school system. I've created a table
'student_list' to hold the data and issued the following command:
LOAD DATA INFILE 'home/karl/Student_List.csv' into
Dilipan,
indeed, there was a race in the printing of thd-query in 4.0.18. But the
problem was probably fixed in May 2004.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB
Thanks Harrison !!!
SELECT char(7); works excellent to simulate a BEEP
with MySQL version 5.0.15 under Windows XP Pro.
It is a simple but effective feature for running scripts.
Regards, Cor
- Original Message -
From: Harrison Fisk [EMAIL PROTECTED]
To: C.R.Vegelin [EMAIL PROTECTED]
David Logan wrote:
Karl Krelove wrote:
I'm trying to import a large amount of data from an Access database
containing information about 9,000+ students in a school system. I've
created a table 'student_list' to hold the data and issued the
following command:
LOAD DATA INFILE
I'm trying to access a database over my local network.
On the server, I had applied the following commands:
shell mysql -u root -p
mysql GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED BY
'novice';
From the otherhost.mydomain, I try a:
shell mysql -h [EMAIL PROTECTED] -u
Hi
I have the following tables:
CREATE TABLE `livres`(
`id` int(10) unsigned NOT NULL auto_increment,
`isbn` varchar(12) NOT NULL default '',
'titre' varchar(80) NOT NULL default '',
`auteur` int(10) unsigned NOT NULL default '0',
`categorie` varchar(60) NOT NULL default '',
PRIMARY KEY
Jørn Dahl-Stamnes [EMAIL PROTECTED] wrote on 12/17/2005 02:12:38
PM:
I'm trying to access a database over my local network.
On the server, I had applied the following commands:
shell mysql -u root -p
mysql GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED
BY
'novice';
Responses intermixed. See below ...
news [EMAIL PROTECTED] wrote on 12/17/2005 03:16:48 PM:
Hi
I have the following tables:
CREATE TABLE `livres`(
`id` int(10) unsigned NOT NULL auto_increment,
`isbn` varchar(12) NOT NULL default '',
'titre' varchar(80) NOT NULL default '',
^ ^
Karl Krelove wrote:
David Logan wrote:
Karl Krelove wrote:
I'm trying to import a large amount of data from an Access database
containing information about 9,000+ students in a school system.
I've created a table 'student_list' to hold the data and issued the
following command:
LOAD
On Saturday 17 December 2005 21:43, [EMAIL PROTECTED] wrote:
I think the most likely culprit will be an unexpected reverse DNS result.
Here are the other likely reasons to get an access denied error:
http://dev.mysql.com/doc/refman/4.1/en/access-denied.html
To the server, does the machine you
11 matches
Mail list logo