File: test/out3-py

Recommend this page to a friend!
  Classes of Nikos M.  >  Dialect PHP SQL Query Builder  >  test/out3-py  >  Download  
File: test/out3-py
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Dialect PHP SQL Query Builder
Build SQL queries from templates
Author: By
Last change: Update of test/out3-py
Date: 5 months ago
Size: 597 bytes


Class file image Download
Dialect.VERSION = 1.2.0

SQL dialect = sqlite

FROM "table" AS "main"
ORDER BY random() ASC



SELECT "trick""ier" AS "trickier","trick'y" AS "tricky"
FROM "table"

FROM "table"
WHERE ("id" IN (SELECT "id"
FROM "anothertable"))

INSERT INTO "table" ("col1","col2")
SELECT "col1","col2"
FROM "anothertable"
WHERE ("id" = 1)

SELECT "anothertable"."col1","anothertable"."col2","dynamictable".*
FROM "anothertable",(SELECT "trick""ier"
FROM "table"
WHERE ("col4" LIKE '%foo%' ESCAPE '\')) AS "dynamictable"
WHERE ("id" = 1)

For more information send a message to info at phpclasses dot org.