Errors in writing code for gps web applications?

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Katelynn Stephanie
Best Answer
Best Answer
Answered By 0 points N/A #179103

Errors in writing code for gps web applications?

qa-featured

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

 

Answered By 0 points N/A #179104

Errors in writing code for gps web applications?

qa-featured

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.

Login/Register to Answer

Related Questions