mass INSERT using HTML field, delimiters

[Choronzon]

What commands do i need to start looking into, to complete a mass insert of info into a database. im looking to insert something like this:

player_name | player_id | location


I want to have a large HTML text field were i can enter multiple lines like this and then have them inserted into the proper tables/fields. Im just looking for a basic theory and commands here so i can start to research and try some simple coding in this area.

[ronverdonk]

Why HTML? Just use a plain text editor and type your data in there, 1 record per line, fields separated by a char like |.
When finished typing, just issue the MySQL LOAD DATA.. command, such as:

LOAD DATA INFILE 'test.txt' INTO TABLE test
  FIELDS TERMINATED BY '|'

For further information see the MySQL manual at load data

Ronald :cool:

[Motoma]

INSERT INTO playerTable (player_name, player_id, location)
VALUES
  ('jake',42,'Portland'),
  ('Brak',34,'Los Santos'),
  ('Gil',1,'Springfield')
 

Hope this helps.

[Choronzon]

why HTML fields? because this database is interacted with via a webpage that is open to any person playing this game, who wishes to store player and locations data. They do not have access to upload .txt files to the server. they would need to make their own .txt file, and copy/paste it to a field.

one question about the LOAD DATA INFILE. I have read up on this commandm, but am not sure were i store the data. were do i put the .txt file? can i put it anywere and point to it with a URL address in the LOAD DATA INFILE command?

[ronverdonk]

I am sorry, but I misunderstood the words 'mass insert' in your original post. I had the idea that you wanted thousands of text lines to be inserted at once.

You start with a form that is submitted when completed by the user. Within that form you can let your users enter the required data in a <textarea> HTML field. After completing the input the user submits the form to your processing script. There you could cleanse (very important) and interpret the entered data (such as recognizing and translating separator chars, new-line chars, tabs, etc.). After that you can build an SQL INSERT or UPDATE statement for the data and process that using mysql_ commands in PHP.

As to your latest post:
No must give a path name for the file to upload, no url.

The LOCAL keyword, if specified, is interpreted with respect to the client end of the connection:

If LOCAL is specified, the file is read by the client program on the client host and sent to the server.
If LOCAL is not specified, the file must be located on the server host and is read directly by the server

Ronald :cool: