Hey there, kudos to your great efforts. I have a simple enquiry as a new sql learner. I learned that identifiers cannot contain reserved keywords of the language. How to make sure that i dont use reserved keywords; is there any caution alert when mistakelny writing any reserved keywords as identifier? Thanks
Thank you for your encouragement. If you use reserved keywords as identifiers, the SQL client you are using is most likely to give you warnings. You can also look at the documentation of the DBMS that you are using, it will have the list of keywords. For example, for MySQL, it has been listed here: dev.mysql.com/doc/refman/8.0/en/keywords.html.
Hey there, kudos to your great efforts.
I have a simple enquiry as a new sql learner.
I learned that identifiers cannot contain reserved keywords of the language.
How to make sure that i dont use reserved keywords; is there any caution alert when mistakelny writing any reserved keywords as
identifier?
Thanks
Thank you for your encouragement.
If you use reserved keywords as identifiers, the SQL client you are using is most likely to give you warnings. You can also look at the documentation of the DBMS that you are using, it will have the list of keywords. For example, for MySQL, it has been listed here: dev.mysql.com/doc/refman/8.0/en/keywords.html.
Very good
Good