Mysql 导出数据表结构

$sql="showcreatetablecategory";
$res=mysql_query($sql)ordie(mysql_error());
while($obj=mysql_fetch_object($res))
...{
print_r($obj);
echo"<hr>";
}
输出
stdClassObject
(
[Table]=>category
[CreateTable]=>CREATETABLE`category`(
`CategoryID`int(10)unsignedNOTNULLdefault'0',
`CategoryName`varchar(80)NOTNULLdefault'',
`ParentID`int(10)unsignedNOTNULLdefault'0',
`Keywords`varchar(255)NOTNULLdefault'',
`ProductCount`mediumint(6)unsignedNOTNULLdefault'0',
`TradeLeadCount`mediumint(6)NOTNULLdefault'0',
`CompanyCount`mediumint(6)NOTNULLdefault'0',
`B2soutletcount`mediumint(6)unsignedNOTNULLdefault'0',
`CategoryType`tinyint(1)NOTNULLdefault'0',
`Section`tinyint(1)unsignedNOTNULLdefault'0',
`IsLeaf`tinyint(1)NOTNULLdefault'1',
`Link`int(10)unsignedNOTNULLdefault'0',
PRIMARYKEY(`CategoryID`),
KEY`GroupName`(`CategoryName`),
KEY`ParentID`(`ParentID`),
KEY`CategoryType`(`CategoryType`),
KEY`Section`(`Section`)
)ENGINE=MyISAMDEFAULTCHARSET=latin1
)

mysql>teeoutmsg.log--注把以后在命令行执行的结构都输入到outmsg.log文件中

mysql>?show
Name:'SHOW'
Description:
SHOWhasmanyformsthatprovideinformationaboutdatabases,tables,
columns,orstatusinformationabouttheserver.Thissectiondescribes
thosefollowing:

SHOW[FULL]COLUMNSFROMtbl_name[FROMdb_name][LIKE'pattern']
SHOWCREATEDATABASEdb_name
SHOWCREATEFUNCTIONfuncname
SHOWCREATEPROCEDUREprocname
SHOWCREATETABLEtbl_name
SHOWDATABASES[LIKE'pattern']
SHOWENGINEengine_name...{LOGS|STATUS}
SHOW[STORAGE]ENGINES
SHOWERRORS[LIMIT[offset,]row_count]
SHOWFUNCTIONSTATUS[LIKE'pattern']
SHOWGRANTSFORuser
SHOWINDEXFROMtbl_name[FROMdb_name]
SHOWINNODBSTATUS
SHOWPROCEDURESTATUS[LIKE'pattern']
SHOW[BDB]LOGS
SHOWPLUGIN
SHOWPRIVILEGES
SHOW[FULL]PROCESSLIST
SHOW[GLOBAL|SESSION]STATUS[LIKE'pattern']
SHOWTABLESTATUS[FROMdb_name][LIKE'pattern']
SHOW[OPEN]TABLES[FROMdb_name][LIKE'pattern']
SHOWTRIGGERS
SHOW[GLOBAL|SESSION]VARIABLES[LIKE'pattern']
SHOWWARNINGS[LIMIT[offset,]row_count]

TheSHOWstatementalsohasformsthatprovideinformationabout
replicationmasterandslaveserversandaredescribedin
[replication-sql]:

SHOWBINLOGEVENTS
SHOWMASTERLOGS
SHOWMASTERSTATUS
SHOWSLAVEHOSTS
SHOWSLAVESTATUS

IfthesyntaxforagivenSHOWstatementincludesaLIKE'pattern'
part,'pattern'isastringthatcancontaintheSQL`%'and`_'
wildcardcharacters.Thepatternisusefulforrestrictingstatement
outputtomatchingvalues.

SeveralSHOWstatementsalsoacceptaWHEREclausethatprovidesmore
flexibilityinspecifyingwhichrowstodisplay.See[extended-show].