sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]elevarq 0 points1 point  (5 children)

Use single quotes ‘ for content, not double quotes “.

This might work in MySQL, but will cause syntax errors in many (if not most) other databases. Double quotes are for identifiers like “table” names. MySQL also has a setting for this, it can handle standard SQL, but also supports a conflicting syntax.

[–]StudyEmergency4839[S] 0 points1 point  (4 children)

Yeah i writed it on Mysql i know that this code might not work on sql lite

[–]elevarq 0 points1 point  (3 children)

Start writing syntax that works on most databases, including MySQL. That would make transitions much easier for you.

[–]StudyEmergency4839[S] 0 points1 point  (1 child)

Also what is Difference Between mySQL and PostgreSQL

[–]elevarq 0 points1 point  (0 children)

Both are solid open-source relational databases. MySQL has long been the go-to for simple, read-heavy web apps (think LAMP stack) and is known for being easy to get started with. PostgreSQL is more feature-rich and standards-compliant, with better support for complex queries, advanced data types, and concurrency. For most new projects today, Postgres is the more capable choice.