ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:changetablesql

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
Last revisionBoth sides next revision
dictionary:changetablesql [2015/09/16 01:19] – [Description] mnewnhamv5:dictionary:changetablesql [2016/01/13 02:06] – ↷ Links adapted because of a move operation mnewnham
Line 4: Line 4:
 == See Also == == See Also ==
  
-[[dictionary:column_attributes|Column Attributes Reference]]\\ +[[v5:dictionary:column_attributes|Column Attributes Reference]]\\ 
-[[dictionary:executesqlarray|executeSqlArray()]]+[[v5:dictionary:executesqlarray|executeSqlArray()]]
  
 == Syntax == == Syntax ==
Line 16: Line 16:
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The method ''changeTableSql()'' creates the SQL statement necessary to make basic changes to a table in the database and populates it with columns defined in ''$fields'' option. If the table does not exist, it behaves like [[dictionary:createtablesql|createTableSql()]]. In order to change the table, the output of the command must be executed with the [[dictionary:executesqlarray|executeSqlArray()]] method.+The method ''changeTableSql()'' creates the SQL statement necessary to make basic changes to a table in the database and populates it with columns defined in ''$fields'' option. If the table does not exist, it behaves like [[v5:dictionary:createtablesql|createTableSql()]]. In order to change the table, the output of the command must be executed with the [[v5:dictionary:executesqlarray|executeSqlArray()]] method.
  
 ===== Parameters ===== ===== Parameters =====
Line 26: Line 26:
 </WRAP> </WRAP>
 ==== $fields ==== ==== $fields ====
-A string holding information regarding the columns to create in the new table. For a detailed description of the format of this string, see [[dictionary:addcolumnsql|addColumnSql()]].+A string holding information regarding the columns to create in the new table. For a detailed description of the format of this string, see [[v5:dictionary:addcolumnsql|addColumnSql()]].
 ==== $tableOptions ==== ==== $tableOptions ====
 An optional array of information that adds information regarding the table creation. This array may also contain field specific information, for example information pertaining to auto-increment fields. An optional array of information that adds information regarding the table creation. This array may also contain field specific information, for example information pertaining to auto-increment fields.
v5/dictionary/changetablesql.txt · Last modified: 2016/03/20 23:33 by mnewnham