56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> show engines;
+------------+---------+--------------------------------------------------------
--------+
| Engine | Support | Comment
|
+------------+---------+--------------------------------------------------------
--------+
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance
|
| MEMORY | YES | Hash based, stored in memory, useful for temporary tabl
es |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign k
eys |
| BerkeleyDB | NO | Supports transactions and page-level locking
|
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disa
ppears) |
| EXAMPLE | NO | Example storage engine
|
| ARCHIVE | YES | Archive storage engine
|
| CSV | NO | CSV storage engine
|
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables
|
| FEDERATED | YES | Federated MySQL storage engine
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
|
| ISAM | NO | Obsolete storage engine
|
+------------+---------+--------------------------------------------------------
--------+
12 rows in set (0.00 sec)
mysql>
sSql = "Drop table if exists P_purchaseorderdetail"
lDCN.Execute sSql
sSql = "Create Table P_purchaseorderdetail ( ID INTEGER NOT NULL AUTO_INCREMENT,Inventoryid INTEGER ,QOH integer,"
sSql = sSql & "PRIMARY KEY (ID),INDEX Inventoryid(Inventoryid) ) ENGINE = InnoDB DEFAULT CHARSET=utf8;"
lDCN.Execute sSql
sSql = "Insert into P_purchaseorderdetail(InventoryID,QOH)"
sSql = sSql & " Select T.InventoryID,T.QOH "
sSql = sSql & " From (" & sCommand & ")T "
lDCN.Execute sSql
'***************************
sCmd = "Drop table if exists P1_purchaseorderdetail"
DCN.Execute sCmd
sCmd = "Create Table P1_purchaseorderdetail ( ID INTEGER NOT NULL AUTO_INCREMENT,Inventoryid INTEGER ,QOH integer,"
sCmd = sCmd & " PRIMARY KEY (ID),INDEX Inventoryid(Inventoryid) )ENGINE = FEDERATED "
sCmd = sCmd & " CONNECTION='mysql://broot:bsuntoyo@192.168.0.41:3306/masterdata/P_purchaseorderdetail'"
DCN.Execute sCmd