Store Comment Text For Free

Comments can be inserted on a separate line or within a Transact-SQL statement. Multiple-line comments must be indicated by /* and */. A stylistic convention often used for multiple-line comments is to begin the first line with /*, subsequent lines with **, and end with */. There is no maximum length for comments.

Syntax Using -- Symbol The -- sign is used in MySQL to add single-line comments to the code. The comment begins with -- and continues until the end of the line. Here's an example of how to use this syntax in MySQL to add a comment: The comment in this example begins with -- and concludes at the end of the line.

Just like any other data that is useful to users, comments should be stored in tables. Each comment in a single cell. In the table row of which the ?key" (foreign key or primary key) represents the ?thing" on which the comment is commenting on.

Single Line SQL Comment. A single-line comment is where you add two dashes ??? (or you can also use a hash ?#? in MySQL) before a line of code. The code will then be ?commented out? and will not be run when you run your statement.

To comment any selected statement in just one keystroke Press CTRL+* with NumLock enabled: Selected statement will be commented automatically. If you select a commented statement the same key combination will uncomment it.

Begin the comment with a slash and an asterisk (/*). Proceed with the text of the comment. This text can span multiple lines. End the comment with an asterisk and a slash (*/).

To create line comments you just use two dashes "--" in front of the code you want to comment. You can comment out one or multiple lines with this technique. In this example the entire line is commented out. This next example shows you how to put the comment on the same line.