Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Cleaning field data using MySQL

forums › forums › Cleaning field data using MySQL

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 19, 2004 at 9:05 am #8371
      BlankCanvas
      Member

      Hi Everyone,

      Hoping someone can help me on this, 😛

      I have just got a large 200Million record database as an export from another system, however for some reason at the end of text field content I have “r” so if the field was NAME and the content was “Stephen” is displays “Stephenr”.

      Is it possible to use MySQL (SQLYOG) to replace the “r” with nothing and update the records. I have tried to do this with PHP but it just kills my server.

      Thanks

      Stephen

    • March 22, 2004 at 2:53 pm #15583
      Shadow
      Member

      Yep, Table -> Import data from CSV, just set fields terminated by to r.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.