Improving splitQuery method. Fixes #22

1 files changed, 14 insertions, 0 deletions

diff --git a/examples/examples.php b/examples/examples.php
index 467f405..af02304 100644
--- a/examples/examples.php
+++ b/examples/examples.php
@@ -74,6 +74,20 @@ $split_statements = array(
         abc\";
     SELECT a,b #comment;
     FROM test;",
+    
+    "
+    -- Drop the table first if it exists
+    DROP TABLE IF EXISTS MyTable;
+
+    -- Create the table
+    CREATE TABLE MyTable ( id int );
+
+    -- Insert values
+    INSERT INTO MyTable (id)
+        VALUES
+        (1),(2),(3),(4);
+
+    -- Done",
 );
 
 // Example statements for removing comments