ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


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
v5:dictionary:changetablesql [2016/01/13 02:06] – ↷ Page moved from dictionary:changetablesql to v5:dictionary:changetablesql mnewnhamv5:dictionary:changetablesql [2016/03/20 23:33] (current) – [Usage] 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.
Line 56: Line 56:
 Array Array
 ( (
-    [0] =>  ALTER TABLE LCTABLE ALTER COLUMN COL1 SET DATA TYPE VARCHAR(60) DEFAULT 'abc'+    [0] =>  ALTER TABLE LCTABLE  
 +            ALTER COLUMN COL1 SET DATA TYPE VARCHAR(60) DEFAULT 'abc'
 ) )
 */ */
v5/dictionary/changetablesql.txt · Last modified: 2016/03/20 23:33 by mnewnham