Menu
in notepad++ SQL language it highlights the word "type" in a blue color but in mysql reserved word list/table* I can't find "type" in that
If "type" is not a reserved word in mysql should I avoid the word "type" and which alternative word should I use.
304
Certain keywords, such as SELECT , DELETE , or BIGINT , are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions.
Microsoft SQL Server uses reserved keywords for defining, manipulating, and accessing databases. Reserved keywords are part of the grammar of the Transact-SQL language that is used by SQL Server to parse and understand Transact-SQL statements and batches.
FIRST and STATUS have been inside this reserved words array because they are part of MySQL commands. STATUS is used in "SHOW STATUS" and FIRST part of the ALTER sytax.
A data type is an attribute that specifies the type of data that the object can hold: integer data, character data, monetary data, date and time data, binary strings, and so on. SQL Server supplies a set of system data types that define all the types of data that can be used with SQL Server.
Definitely, NO.
When I open my Notepad++, I can't seem to find language for MySQL, only SQL is available. So the reason why it is highlighted as blue is because it may be reserved keyword from the other languages.
64
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
