Software: Apache/2.0.54 (Fedora). PHP/5.0.4 

uname -a: Linux mina-info.me 2.6.17-1.2142_FC4smp #1 SMP Tue Jul 11 22:57:02 EDT 2006 i686 

uid=48(apache) gid=48(apache) groups=48(apache)
context=system_u:system_r:httpd_sys_script_t 

Safe-mode: OFF (not secure)

/usr/share/doc/unixODBC-2.2.11/doc/Drivers/txt/   drwxr-xr-x
Free 3.36 GB of 27.03 GB (12.43%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     SupportedSyntax.html (4.45 KB)      -rw-r--r--

Supported SQL Syntax

This ODBC driver is limited in its support of SQL by the sqp library. But, in fact, this driver may be limited even more. So your best indication of supported SQL is to simply try the SQL (i.e. in isql) before commiting yourself to it. The idea is that any supported SQL in this driver will be availible in other drivers/data sources. So this driver may be considered the "lowest common denominator".

Case Sensitivity

sqp is case insensitive. This is inherited by this driver. However; this driver is often case sensitive when working with table names because they may map directly to file names.

Supported Syntax

Here are some SQL syntax examples which are known to work;

- CREATE TABLE -

CREATE TABLE TableName ( Col1 VARCHAR(100), Col2 VARCHAR(100) )
 

Note:

The only column data type supported is VARCHAR and the length is always the default length compiled into the driver (i.e. 4096). So the length specified is ignored. The reason for this is simple; the table file format only contains column names and data. This may be resolved with a catalog file in the future.

- DROP TABLE -

DROP TABLE TableName
 

Note:

This does an rm on the table file. This means that it will be gone forever.

- SELECT -

SELECT * FROM TableName
SELECT Col1, Col2, Col3 FROM TableName
SELECT * FROM TableName WHERE Col1 = 'value' AND Col2 >= 'value'
SELECT * FROM TableName ORDER BY Col1, Col2

Note:

1. You can only AND two expressions (no OR).
2. A column name must be on the left and a string must be on the right of each expression.
3. You can not do table joins.
4. Aggregating is not supported.
5. DISTINCT is not supported.

- INSERT -

INSERT INTO TableName VALUES ( 'value1', 'value2' )
 

Note:

Specifying specific columns such as (col1,co2) VALUES ('val1','val2') is not supported.

- DELETE -

DELETE TableName
DELETE TableName WHERE Col1 <= 'value1' AND Col2 > 'value2'
 
 

- UPDATE -

UPDATE TableName SET Col1 = 'value1', Col2 = 'value2' WHERE Col1 > 'value1'