Blue Breeze

보호되어 있는 글입니다.

Squel.js npm install squel var squel = require("squel"); log( squel.select() .from("students") .field("name") .field("MIN(test_score)") .field("MAX(test_score)") .field("GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ')") .group("name") .toString() ); /* SELECT name, MIN(test_score), MAX(test_score), GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') ..

select * from master.dbo.sysdatabases; select * from sysobjects where xtype='u'; select * from information_schema.columns where table_name='table_name';

연관배열로 필드값을 가져올경우 [code php] $sql = "SELECT FIELD FROM TABLE"; $parse = @OCIParse($connect,$sql); @OCIExecute($parse); while(@OCIFetchInto($parse, $data, OCI_ASSOC+OCI_RETURN_NULLS|OCI_RETURN_LOBSdescriptor)) { $data = @array_change_key_case($data, CASE_LOWER); $FIELD = $rs["FIELD"]; } $sql = "SELECT FIELD FROM TABLE"; $parseq = @OCIParse($connect,$sql); @OCIExecute($parse); @OCIFetchinto($parse,..