Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
204
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. LOAD DATA INFILE '/path/file' INTO TABLE cdr_records (@dummy,
  2. @dummy,
  3. @dummy,
  4. @dummy,
  5. dateTimeOrigination,
  6. @dummy,
  7. @dummy,
  8. @dummy,
  9. callingPartyNumber,
  10. @dummy,
  11. @dummy,
  12. @dummy,
  13. @dummy,
  14. @dummy,
  15. @dummy,
  16. @dummy,
  17. @dummy,
  18. @dummy,
  19. @dummy,
  20. @dummy,
  21. @dummy,
  22. @dummy,
  23. @dummy,
  24. @dummy,
  25. @dummy,
  26. @dummy,
  27. @dummy,
  28. @dummy,
  29. @dummy,
  30. originalCalledPartyNumber,
  31. finalCalledPartyNumber,
  32. @dummy,
  33. @dummy,
  34. @dummy,
  35. @dummy,
  36. @dummy,
  37. @dummy,
  38. @dummy,
  39. @dummy,
  40. @dummy,
  41. @dummy,
  42. @dummy,
  43. @dummy,
  44. @dummy,
  45. @dummy,
  46. @dummy,
  47. @dummy,
  48. @dummy,
  49. @dummy,
  50. @dummy,
  51. pkid,
  52. @dummy,
  53. @dummy,
  54. @dummy,
  55. @dummy,
  56. duration,
  57. @dummy,
  58. @dummy,
  59. @dummy,
  60. @dummy,
  61. @dummy,
  62. @dummy,
  63. @dummy,
  64. @dummy,
  65. @dummy,
  66. @dummy,
  67. @dummy,
  68. @dummy,
  69. @dummy,
  70. @dummy,
  71. @dummy,
  72. @dummy,
  73. @dummy,
  74. @dummy,
  75. @dummy,
  76. @dummy,
  77. @dummy,
  78. @dummy,
  79. @dummy,
  80. @dummy,
  81. @dummy,
  82. @dummy,
  83. @dummy,
  84. @dummy,
  85. @dummy,
  86. @dummy,
  87. @dummy,
  88. @dummy,
  89. @dummy,
  90. @dummy,
  91. @dummy,
  92. @dummy,
  93. @dummy,
  94. @dummy,
  95. @dummy,
  96. @dummy,
  97. @dummy,
  98. @dummy,
  99. @dummy,
  100. @dummy,
  101. @dummy,
  102. @dummy,
  103. @dummy,
  104. @dummy) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' IGNORE 2 LINES;
  105.  
  106. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' IGNORE 2 LIN' at line 104
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement