sql script file comments 1

[murrayja]

Can anyone tell me how to comment out a line in an sql script file being input to mysql on the command line?
(eg: >mysql source \scriptfile.txt)

 

[DonQuichote]

The most standard way is to start the line with two minus signs and a space, Like:

-- This is a comment

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[MDCrab]

there are also block comments; e.g.,

/*
set v = 5;
set h = 3;
*/

-- doesn't get executed.

btw, two dashes by themselves don't produce a comment. You need the space after them.

--not a comment
-- is a comment.

 

[murrayja]

thank you

 

[AdaHacker]

btw, two dashes by themselves don't produce a comment. You need the space after them.

Actually, that's not correct. No space is necessary - all you need is the 2 dashes. In fact, you can have pretty much any character you want after the double dashes, including more dashes. (Refer to page 83 of the ANSI SQL-92 standard.)

 

[AdaHacker]

Oh, wait, you're talking MySQL-specific. In that case, never mind, you're right. Sorry, guess I'm wasn't paying attention to which forum I'm in.

 

[r937]

there's nothing wrong with quoting ANSI standards if someone says "The most standard way is ..."



r937.com | rudy.ca