PHP Classes

File: test/js/out3.txt

Recommend this page to a friend!
  Classes of Nikos M.   Dialect PHP SQL Query Builder   test/js/out3.txt   Download  
File: test/js/out3.txt
Role: Documentation
Content type: text/plain
Description: Documentation
Class: Dialect PHP SQL Query Builder
Build SQL queries from templates
Author: By
Last change:
Date: 1 year ago
Size: 562 bytes
 

Contents

Class file image Download 
Dialect.VERSION = 1.4.0

SQL dialect = postgresql

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

"trick""ier"

E'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 E'%foo%')) AS "dynamictable"
WHERE ("id" = 1)