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
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
Â
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.
