Inserting 100x and 100y coordinates in mysql table - easy

Posted on 16th Feb 2014 07:03 pm by admin

Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y int 3' in an easy way with maybe a for loop or something?

I want the data entered to be like this:

0x 0y
1x, 0y
2x,0y
3x,0y


all the way up to 100x and 100y.

All feedback appreciated

Your Answer:

Login to answer

Other forums

Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.

I have maxminds geoip lite installed and i

problem getting my contact form working
Yeah I know this is a pretty basic problem, but it's been a while since I've worked with PHP and I'm

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth