How To Use SQL Basics

Must we alwaysss use semicolon after every SQL line like:

CREATE TABLE hello(
id INTEGER;
name TEXT;

);

or just use a comma?

Hi, welcome to the forums!

Semicolon.
unless you’re creating CTE’s (temporary tables) and then you use a comma in between them.

1 Like

Thank you for helping me, I really appreciate it

1 Like