What is SQL syntax and MySQL?

Question

I'm trying to send in an application and everytime I hit send, this comes up...

Could not run the query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Pizza Cincinnati, Ohio November 2003 ' at line 1

What does it mean? And how do I fix it to finish the online application?
Please help!!

Answer 1

SQL (Structured Query Language) (pronounced /ɛsk'juːˈɛl /)[1] is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.[2][3]



SQL is a programming language for querying and modifying data and managing databases. SQL was standardized first by the ANSI and later by the ISO. Most database management systems implement a majority of one of these standards and add their proprietary extensions. SQL allows the retrieval, insertion, updating, and deletion of data. A database management system also includes management and administrative functions. Most – if not all – implementations also include a command-line interface (SQL/CLI) that allows for the entry and execution of the language commands, as opposed to only providing an application programming interface (API) intended for access from a graphical user interface (GUI).

Answer 2

This message means that the person who wrote the application form goofed up. You managed to put something in that broke their database. Maybe you added quote marks or something like that? Remove all quote marks and things that SQL might get confused with.

Give us the address so we can break it some more.

Answer 3

MS sq. and MySQL are very comparable, however the syntax of each varies slightly. understanding the syntax of one, you may desire to quite write the different, yet once you attempt to execute a fact from one language on yet another, you will get an errors on the server because of the fact they are no longer comparable, fairly on long statements.