2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenCREATE TABLE foo (
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen col1 INT NOT NULL PRIMARY KEY,
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen col2 VARCHAR(100)
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen);
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenSELECT * FROM foo;
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenINSERT INTO foo (col1, col2) VALUES (1, 'something'), (5, 'something else');
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2d49f150b4bce6f2f59a84e268e4777901c3e42cTimo Sirainen-- This is an SQL comment with a email address: username@example.com
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenDELETE FROM foo WHERE id=5;
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenSELECT COUNT(col1) FROM foo;
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen-- This en an SQL comment with strange characters: <, > and &
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenDROP TABLE "foo";
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenCREATE TABLE "foo""";
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen/* Other supported comment */
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenSELECT 123.45 + 543E-2 FROM DUAL;
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen/* /* Comment inside comment */ */
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen-- Text values:
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo SirainenINSERT INTO foo(col2) VALUES ('this'), ('and this'), ('and '' too');
2a34e2be33f8a17d21384a5527ed9f75f4d270e0Timo Sirainen