|
mysql> CREATE TABLE test_csv (col01 char(4),col02 char(4),col03 char(4)) ENGINE=CSV;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO test_csv VALUES (‘aaaa’,‘aaaa’,‘aaaa’),(‘bbbb’,‘bbbb’,‘bbbb’),(‘cccc’,‘cccc’,‘cccc’);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM test_csv;
+-------+-------+-------+
| col01 | col02 | col03 |
+-------+-------+-------+
| aaaa | aaaa | aaaa |
| bbbb | bbbb | bbbb |
| cccc | cccc | cccc |
+-------+-------+-------+
3 rows in set (0.00 sec)
[root@localhost var]# vi CSV_TEST/test_csv.CSV
“aaaa”,“aaaa”,“aaaa”
“bbbb”,“bbbb”,“bbbb”
“cccc”,“cccc”,“cccc”
“dddd”,“dddd”,“dddd”
~
mysql> FLUSH TABLE;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM test_csv;
+-------+-------+-------+
| col01 | col02 | col03 |
+-------+-------+-------+
| aaaa | aaaa | aaaa |
| bbbb | bbbb | bbbb |
| cccc | cccc | cccc |
| dddd | dddd | dddd |
+-------+-------+-------+
4 rows in set (0.00 sec)
|
|