SQL2003 H2 HSQLDB Oracle MySQL PostgreSQL
/* This is some sample SQL, please edit or cut/paste to try the parser with your own SQL. If you are using features like MySQL style strings ( i.e. 'O\'Brian' ) or other feature that require a particular backend be sure to select the proper option in the drop down. */ create table contact (id bigint, category_id bigint, firstname varchar(50), lastname varchar(50), email varchar(100)); insert into contact (firstname, lastname) values ('O''Brian', 'O''Shea'); insert into contact (firstname, lastname, email) values ('Mark', 'Farnsworth', 'farnsworth2009@gmail.com'); update contact set firstname = 'Sam' where lastname = 'O''Shea'; select lastname, firstname, email from contact where lastname like 'Farns%'; delete from contact where lastname = 'O''Shea';