CODEWITHSUNDEEP
mysql
benstpierre
benstpierre

Reputation: 33571

Why are these comments in a mysql file blowing up?

On the Linux command line I call this script via the mysql terminal using source...

--First insert new template types

insert into TemplateType(id,name,size)
        values (10,'Feature Sheet','8.5x11 ss');
insert into TemplateType(id,name,size)
        values (11,'Feature Sheet','8.5x11 ds');
insert into TemplateType(id,name,size)
        values (12,'Feature Sheet','11x17');

When I do I get an error saying my sql syntax is invalid. Is this not the correct way to comment an sql file?

Upvotes: 1

Views: 51

Answers (1)

benstpierre
benstpierre

Reputation: 33571

Apparently you need whitespace after the -- or use a # instead....

http://dev.mysql.com/doc/refman/5.0/en/comments.html

Upvotes: 1

Related Questions