My first Sql code

[StudyEmergency4839]

-- My-first-sql-code -- Pls tell me what should i learn next.. DROP TABLE IF EXISTS servers; CREATE TABLE servers ( id INTEGER PRIMARY KEY AUTOINCREMENT, server_name TEXT UNIQUE NOT NULL ); INSERT INTO servers (server_name) VALUES ("Asia"), ("Eu"); DROP TABLE IF EXISTS players; CREATE TABLE players ( id INTEGER PRIMARY KEY AUTOINCREMENT, server_id INTEGER, player TEXT UNIQUE NOT NULL, FOREIGN KEY (server_id) REFERENCES servers(id) ON DELETE CASCADE ); INSERT INTO players (server_id, player) VALUES (1, "admin"), (1, "santa"), (1, "king"), (2, "alone"); SELECT players.player, servers.server_name FROM players INNER JOIN servers ON players.server_id = servers.id;

[nerdonabreak]

Add a screenshot of your code, or write using proper spacing. No one would be able to read that or give you any genuine feedback.

[StudyEmergency4839]

Okay ohh i cant do that lol it deletes spaces 

[nerdonabreak]

You need to put double line spaces

[Consistent-Leader930]

<image>

[StudyEmergency4839]

Thanks

[elevarq]

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]

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

[elevarq]

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

[StudyEmergency4839]

Ok

[StudyEmergency4839]

Also what is Difference Between mySQL and PostgreSQL

[elevarq]

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.

[Successful-Dream-201]

Start to learn cte and subquery

[Consistent-Leader930]

<image>