[EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ cat abc.txt -n 1 "A1","B1","C1" 2 "A2","B2","C2" 3 "A3","B3","C3" [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 21 to server version: 5.0.27
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | alpha | | bravo | | charlie | | delta | | mysql | | test | +--------------------+ 7 rows in set (0.00 sec) mysql> use delta; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +-----------------+ | Tables_in_delta | +-----------------+ | abc | +-----------------+ 1 row in set (0.00 sec) mysql> describe abc; +-------+------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------+------+-----+---------+-------+ | a | text | NO | | | | | b | text | NO | | | | | c | text | NO | | | | +-------+------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> LOAD DATA INFILE '/home/thufir/abc.txt' INTO TABLE delta.abc; ERROR 13 (HY000): Can't get stat of '/home/thufir/abc.txt' (Errcode: 13) mysql> mysql> quit Bye [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ date Thu Apr 12 01:35:36 BST 2007 [EMAIL PROTECTED] ~]$ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]