Differences

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

--- v5:dictionary:changetablesql [2016/01/13 02:06] – ↷ Links adapted because of a move operation mnewnham
+++ v5:dictionary:changetablesql [2024/11/29 14:08] (current) – [Usage] remove trailing comma in $flds definition (incorrect syntax) dregad
@@ Line 26: / Line 26: @@
 </WRAP>
 ==== $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 [[v5: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:column_attributes]].
 ==== $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.
@@ Line 44: / Line 44: @@
 $flds = "
-   COL1 C(60) NOTNULL DEFAULT 'abc',
+   COL1 C(60) NOTNULL DEFAULT 'abc'
   ";
@@ Line 56: / Line 56: @@
 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'
 )
 */