Errors in writing code for gps web applications?

Asked By elin ortie 10 points N/A Posted on - 01/31/2013

Hello ! I am working on GPS web applications database in MySQL.

While creating a listing's I am getting an unexpected error.Code is mentioned below :

DROP TABLE IF EXISTS golook;
CREATE TABLE golook(
     lon FLOAT,
     lon FLOAT,
     address TEXT,
     title TEXT,
     url TEXT,
     summary TEXT );
Kindly provide me solutions.Thanks

• Status: Open
• Question Views: 682
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Katelynn Stephanie

Go To Solution

Best Answer

Best Answer

Answered By Katelynn Stephanie 0 points N/A #179103

Errors in writing code for gps web applications?

Hello Elin,

Without knowing what the error message or error code is that you are receiving, but here's something I notice right off the top.

You are creating two columns with the name lon.  I would recommend calling them different names, or if they are coordinates, perhaps call them lonx and lony.

You might want to include the SHOW WARNINGSG or SHOW ERRORSG statement after you attempt the CREATE TABLE statement to see what warnings/errors you are receiving.

I hope this helps.

Katelynn

 

About Katelynn Stephanie

Questions
0

Answers
26

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 02/09/2013
• Question Category: MySQL Server

Answered By Whudson Audrey 0 points N/A #179104

Errors in writing code for gps web applications?

Hi there,

Your message isn't obvious but I recognized you are referring to a number of problems with your databases within MySQL. MySQL Database – The device is dependent on some sort of data-centric design and style along with just about all surgical procedures along with ancient info usually are stored in the MySQL databases.

I'll suggest one to consider helping by MySQL website.

Whenever you were being in some sort of databases it's strenuous desk.

Remember to illustrate your problem.

Regards.

About Whudson Audrey

Questions
3

Answers
102

Best Answers
59

• Vote Up 0 Vote Down

• Posted on - 02/24/2013
• Question Category: MySQL Server