Why is "depth" highlighted in an *.sql file?
Hellp Npp forum!
Question: Why is the word “depth” highlighted in an .sql file?
Below is an mysql database table. The column heading “depth” displays in bold blue in my Notepad++ window. The code below is in an .sql file.
I have checked the PHP manual and the MySQL manual. The word “depth” is not a reserved word or a keyword in either php or mysql.
I have got a screen shot but I can’t figure out how to insert an image in a post on this forum.
CREATE TABLE IF NOT EXISTS
cat_idsmallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘Specific id for each of the categories.’,
main_idsmallint(5) unsigned DEFAULT NULL,
parent_idsmallint(5) unsigned DEFAULT NULL,
childrenvarchar(255) DEFAULT NULL,
**depth**tinyint(4) DEFAULT NULL,
categoryvarchar(255) DEFAULT NULL COMMENT ‘’,
display_catvarchar(255) DEFAULT NULL COMMENT ‘’,
PRIMARY KEY (
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
Thank you in advance.
Why is the word “depth” highlighted in an .sql file?
I don’t know the answer to why? , but you can delete it from the appropriate place in langs.xml (under the “sql” language) and then it will no longer be specially highlighted in bold blue for you.
This thread will tell you about how to post a screenshot here: https://notepad-plus-plus.org/community/topic/14262/how-to-markdown-code-on-this-forum
If this (or ANY posting on the Notepad++ Community site) is useful, don’t reply with a “thanks”, simply up-vote ( click the
^ 0 varea on the right ).
MAPJe71, Scott Sumner;
Thank you for responding to my question. I appreciate the help.
I think it would be a good idea for me to change the column name to a different name.
Thanks again. : )