When running files using the mysql <  filename command, in case there was an error in the batch file, What would happen since it exits mysql immediately?Thanks.

Why is this query written like so: :::SQL SELECT name,birthdate FROM person;   instead of: :::SQL SELECT name, birthdateFROM person;

I think I lack the intuition to iterate through the MySQL code. I believe that practice and exercises will help me more.

Will there be an error if we try to sort with NULL values?

What does the phrase ":::SQL" mean?

I'm actually a little bit confused about the difference between WHERE and HAVING. They both seem to filter rows, so when should I use one versus the other?

I tried running the mysql interaction in my terminal by running the mysql command. I'm wondering why it didn't work?

When using the WHERE clause, how does MySQL handle rows where the value is NULL?

Will we be using database viewers that are found in vscode? Also what are some uses of the data functions regarding database orginization?

Can SELECT and WHERE also be used to select rows with certain column conditions?

My question is about what are the key differences between different SQL versions. I learned some sqlite3 before, and I'm wondering how it differs from MySQL. I have never used the use statement or <>, so I'll want to learn whether these examples and others are universal across the different variants or not. I also wonder what is the benefit of using the mysql interpreter over different applications to visualize databases like DBbrowser?