ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:column_attributes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
v5:dictionary:column_attributes [2016/03/20 23:30] – mnewnhamv5:dictionary:column_attributes [2016/04/03 01:29] – [CONSTRAINT] mnewnham
Line 53: Line 53:
 </WRAP> </WRAP>
 ==== AUTO or AUTOINCREMENT ==== ==== AUTO or AUTOINCREMENT ====
-Creates the column as auto-increment. Support for this varies from one database to another. Some databases designate a field with an auto-increment flag as the primary key.+Creates the column as auto-increment. Support for this varies from one database to another. Some databases designate a field with an auto-increment flag as the primary key, and most databases only allow a single column in a table to be designated as auto-increment.
  
 ----------------------- -----------------------
Line 60: Line 60:
 </WRAP> </WRAP>
 ==== CONSTRAINT ==== ==== CONSTRAINT ====
 +Adds a constraint to column. The syntax for the constraint must be defined as required by the database.
 -------------------------- --------------------------
 <WRAP right box 150px> <WRAP right box 150px>
Line 90: Line 90:
  
 ----------------------------------- -----------------------------------
 +<WRAP right box 150px>
 +**Usage: Column**
 +</WRAP>
 ==== INDEX ==== ==== INDEX ====
 +Creates a single column index using the same name as the column, with 'idx_' prepended to the name, e.g. a column of name ''column1'' will create an index of name ''idx_column1''.
 ------------------------------- -------------------------------
-==== KEY ==== 
  
---------------------------------+<WRAP right box 150px> 
 +** Usage: Any ** 
 +</WRAP>
 ==== NOQUOTE ==== ==== NOQUOTE ====
 +Prevents ADOdb from applying the normal quoting rules to tables, columns and indexes. For example, a column name that contains a special character such as  //**some-column**// will be automatically quoted to **//'some-column'//**. This tag prevents the behavior.
 -------------------------------- --------------------------------
 <WRAP right box 150px> <WRAP right box 150px>
Line 108: Line 112:
 **Usage: Column** **Usage: Column**
 </WRAP> </WRAP>
-==== PRIMARY ====+==== PRIMARY or KEY ====
 Indicates if the column is part of the [[wp>Unique Key|Primary Key]] of the table. Indicates if the column is part of the [[wp>Unique Key|Primary Key]] of the table.
 --------------------------- ---------------------------
Line 122: Line 126:
 </WRAP> </WRAP>
 ==== UNSIGNED ==== ==== UNSIGNED ====
 +Creates an unsigned integer.
v5/dictionary/column_attributes.txt · Last modified: 2022/09/02 04:11 by mnewnham