STRUCTURED DATA UNSTRUCTURED DATA

[root@ib infobright]#./install-infobright.sh 
--datadir=/u01/mysql/data 
--cachedir=/u01/mysql/cache 
--config=/u01/mysql/my.cnf 
--port=3306 
--socket=/tmp/mysql3306.sock 
--user=mysql 
--group=mysql
 
Infobright installation script is running...
Checking system configuration...
strings: '/lib64/libc.so.6': No such file
expr: missing operand

[root@ib lib]# ln -s /lib/libc.so.6 /lib64

root@test 04:12:04>CREATE TABLE `test` (
    ->   `id` int(11) NOT NULL AUTO_INCREMENT,
    ->   `char_1` varchar(30) NOT NULL,
    ->   `gmt_create` datetime NOT NULL,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB  DEFAULT CHARSET=gbk;
Query OK, 0 rows affected (0.00 sec)
 
root@test 04:12:34>insert into test(char_1,gmt_create) values('李杰',now());
Query OK, 1 row affected (0.00 sec)
 
root@test 04:12:40>select * from test into outfile '/tmp/test.txt' fields terminated by ',';
Query OK, 1 row affected (0.00 sec)
 
[test@mac1 /tmp]
$more /tmp/test.txt
1,李杰,2011-10-09 16:12:40

mysql> CREATE TABLE `test` (
    ->   `id` int(11) NOT NULL ,
    ->   `char_1` varchar(30) NOT NULL,
    ->   `gmt_create` datetime NOT NULL
    -> ) ENGINE=BRIGHTHOUSE  DEFAULT CHARSET=gbk;
Query OK, 0 rows affected (0.01 sec)
 
mysql> load data infile '/tmp/test.txt' into table test fields terminated by ',';
Query OK, 1 row affected (0.05 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0

mysql> select * from test;
+----+--------+---------------------+
| id | char_1 | gmt_create          |
+----+--------+---------------------+
|  1 | ????   | 2011-10-09 16:12:40 |
+----+--------+---------------------+
1 row in set (0.00 sec)

mysql> set names 'gbk';
Query OK, 0 rows affected (0.00 sec)
 
mysql> set character_set_server = 'gbk';
Query OK, 0 rows affected (0.00 sec)
 
mysql> set character_set_database ='gbk';
Query OK, 0 rows affected (0.00 sec)
 
mysql> load data infile '/tmp/test.txt' into table test fields terminated by ',';
Query OK, 1 row affected (0.05 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
 
mysql> select * from test;
+----+--------+---------------------+
| id | char_1 | gmt_create          |
+----+--------+---------------------+
|  1 | 李杰   | 2011-10-09 16:12:40 |
+----+--------+---------------------+

mysql> CREATE TABLE `test_latin` (
    ->   `id` int(11) NOT NULL ,
    ->   `char_1` varchar(30) NOT NULL,
    ->   `gmt_create` datetime NOT NULL
    -> ) ENGINE=BRIGHTHOUSE  DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)
 
mysql> load data infile '/tmp/test.txt' into table test_latin fields terminated by ',';
Query OK, 1 row affected (0.07 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
 
mysql> select * from test_latin;
+----+--------+---------------------+
| id | char_1 | gmt_create          |
+----+--------+---------------------+
|  1 | 李杰   | 2011-10-09 16:12:40 |
+----+--------+---------------------+
1 row in set (0.00 sec)