I need a unknown amount of coordinates field (or few fields) How to go about doing this?

Using MySQL I need to have a list (possibly long list) of x,y coordinates. How should I go about this?

Apologies for the amazing amount of vague in this question! I didn't want to explain my entire project but I suppose some more explanation is in order for this to make any sense as a question.

Ok I'm doing a a map/direction web application for a client (no, I've looked into Google Maps API, but I need to map their buildings/campus so I don't think that applies well). So my current plan is to create some PHP scripts that will run through dijkstra's algorithm (I'm purposely dumbing this down quite a bit because, again, I don't want to explain th开发者_如何学运维e whole project) but since that algorithm is based on the use of a graph I was going to have an Edge table that will contain various Coords so that I know, in the image, how to draw my lines. Does this make any more sense to you guys now? Again I apologize, I should've gone a little more into my issue originally.

---

making a lot of assumptions since your question is vague...

Use two tables with a foreign key, this is the standard approach to model a one to many relationship

create table table1 (
id int
--more columns presumably
)
create table coordinates (
id int,
table_id int --foreign key with table1,
x int,
y int
)

---

MySQL is a database which, stores data. You can create a table with XCoord and YXoord fields which can handle millions of rows with ease.

CREATE TABLE Coordinates( id int(11) NOT NULL Auto_increment,
  X double NOT NULL,
  Y double NOT NULL,
PRIMARY KEY (id)
)