Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> LOAD DATA INFILE '/tmp/m.csv' INTO TABLE ronnie;
- ERROR 1146 (42S02): Table 'test.ronnie' doesn't exist
- mysql> LOAD DATA INFILE '/tmp/m.csv' INTO TABLE content;
- Query OK, 1 row affected, 2 warnings (0.00 sec)
- Records: 1 Deleted: 0 Skipped: 0 Warnings: 2
- mysql> select * from content;
- +------------+---------------------+
- | content_id | timestamp |
- +------------+---------------------+
- | 2010 | 2010-06-06 02:56:19 |
- +------------+---------------------+
- 1 row in set (0.00 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement