Advertisement
Guest User

Untitled

a guest
May 29th, 2017
505
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. mysql> LOAD DATA INFILE '/tmp/m.csv' INTO TABLE ronnie;
  2. ERROR 1146 (42S02): Table 'test.ronnie' doesn't exist
  3. mysql> LOAD DATA INFILE '/tmp/m.csv' INTO TABLE content;
  4. Query OK, 1 row affected, 2 warnings (0.00 sec)
  5. Records: 1 Deleted: 0 Skipped: 0 Warnings: 2
  6.  
  7. mysql> select * from content;
  8. +------------+---------------------+
  9. | content_id | timestamp |
  10. +------------+---------------------+
  11. | 2010 | 2010-06-06 02:56:19 |
  12. +------------+---------------------+
  13. 1 row in set (0.00 sec)
  14.  
  15. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement