File: test/out3-php

Recommend this page to a friend!
  Classes of Nikos M.  >  Dialect PHP SQL Query Builder  >  test/out3-php  >  Download  
File: test/out3-php
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-php
Date: 5 months ago
Size: 570 bytes
 

Contents

Class file image Download
Dialect.VERSION = 1.2.0

SQL dialect = mysql

SELECT *
FROM `table` AS `main`
ORDER BY RAND() 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%')) AS `dynamictable`
WHERE (`id` = 1)

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