File: delimiters-normal.sql

package info (click to toggle)
phing 3.1.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 9,328 kB
  • sloc: php: 59,826; xml: 9,770; sql: 78; makefile: 39; sh: 14
file content (21 lines) | stat: -rw-r--r-- 627 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
-- this string is a comment and should be ignored
// this is also a comment according to phing
# even this is still a comment

insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column');

delete
from
foo where bar = '${bar.value}'; update dump -- I should not be ignored
set message = 'I am a string with \\ backslash \' escapes and semicolons;'; 

delimiter //

-- note: the double slash is no longer a comment
create procedure setfoo(newfoo int)
begin
    set @foo = newfoo;
end
//

insert into dump (message) values ('I am a statement not ending with a delimiter')