Jump to content


Photo

mysql upload problem


  • Please log in to reply
1 reply to this topic

#1 visken

visken
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 20 June 2006 - 04:06 PM

Hi,

I am quite new to MySQL and need some help with uploading data from a textfile.
The file looks as:

1|Toy Story (1995)|01-Jan-1995||http://us.imdb.com/M/title-exact?Toy%20Story%20(1995)
2|GoldenEye (1995)|01-Jan-1995||http://us.imdb.com/M/title-exact?GoldenEye%20(1995)
3|Four Rooms (1995)|01-Jan-1995||http://us.imdb.com/M/title-exact?Four%20Rooms%20(1995)
4|Get Shorty (1995)|01-Jan-1995||http://us.imdb.com/M/title-exact?Get%20Shorty%20(1995)
5|Copycat (1995)|01-Jan-1995||http://us.imdb.com/M/title-exact?Copycat%20(1995)

I have a proble with uploading this file because of the brackets. I woul like to have the information between brackers in a column. If this is unpossible I would like to have the date (eg 01-Jan-1995) in a column as timestamp.

Does anyone knows how I could do this?

#2 craygo

craygo
  • Staff Alumni
  • Advanced Member
  • 1,973 posts
  • LocationRhode Island

Posted 20 June 2006 - 05:15 PM

If you are looking to strickly do this with mysql as a way to populate your database, you may want to look at the MySQL forums instead of php.

If you are looking for a way to parse a text file and insert it into the table, then you are in the right place.

Let us know which way you are going

Ray




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users