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
 

Contents

Class file image Download
Dialect.VERSION = 1.2.0

SQL dialect = sqlite

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

"trick""ier"

'trick''\\ier'

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

SELECT *
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.