# 數據庫字段處理 | 傳入參 | 說明 | | --- | --- | | handle | [ 必填 ] 處理類型 | | table | [ 必填 ] 表名 | | other | [ 選填 ] 配置參數數組 | * 樣式 ~~~ $Sql->alert($handle,$table,$other); ~~~ * auto設置主鍵初始值 ~~~ $back = $Sql -> alert("auto",$table,['value'=>"100001"]); ~~~ * add新增字段 ~~~ $other = []; $other['field'] = 'uuid char(36) NOT NULL default ""'; $back = $Sql -> alert("add",'table',$other); ~~~ * edit編輯字段 ~~~ $other = []; $other['field1'] = 'field_1 int(10) NOT NULL default "0"'; $other['field2'] = 'field_2 char(255) NOT NULL default ""'; $back = $Sql -> alert("edit",$table,$other); ~~~ * index_add索引新增 ~~~ $other = []; $other['index_name'] = 'field_1,field_2'; $back = $Sql -> alert("index_add",$table,$other); ~~~ * index_del索引新增 ~~~ $other = []; $other[] = 'index_name_1'; $other[] = 'index_name_2'; $back = $Sql -> alert("index_del",$table,$other); ~~~ * unique唯一索引 ~~~ $other = []; $other['field'] = ['field_1','field_2']; $other['name'] = 'unique_name'; $back = $Sql -> alert("unique",$table,$other); ~~~ | 修訂時間 | 開發版本 | | --- | --- | | 2020-09-10 | 寶知林 - 服務端 |