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

PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY

ClientScript.RegisterClientScriptBlock Issue
This is what I haveview plaincopy to clipboardprint?Protected Sub posrback_Click(ByVal sender As Obj

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

xml
<?php

echo "<h1>XML Articles</h1>";

$home

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

Problem with creating FI documents
Hi, Experts!

when i create Fi doc. with standart transaction, i ve been had such problem

Developing Ajax-enabled ASP.Net applications for the iPhone
I would like to develop Ajax web applications using Visual Studio that are optimized for the iPhone.

Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo

Can't seem to capture a variable in a chained select
I'm *this* close to having a chained select running but for some reason it doesn't seem to be pickin