netezza命令语法简要

《netezza命令语法简要》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、nzsqlThisisnzsql,theNetezzaSQLinteractiveterminal.Usage:nzsql[options][dbname[username][password]]Options:-aEchoallinputfromscript-AUnalignedtableoutputmode(-Pformat=unaligned)-cRunonlysinglequery(orslashcommand)andexit-dSpecifydatabasenametoconnectto(def

2、ault:system)-DSpecifydatabasenametoconnectto(default:system)-eEchoqueriessenttobackend-EDisplayqueriesthatinternalcommandsgenerate-fExecutequeriesfromfile,thenexit-FSetfieldseparator(default:"

3、")(-Pfieldsep=)-hostSpecifydatabaseserverhost

4、(default:domainsocket)-HHTMLtableoutputmode(-Pformat=html)-lListavailabledatabases,thenexit-nDisablereadline-oSendqueryoutputtofilename(or

5、pipe)-portSpecifydatabaseserverport(default:hardwired)-Pvar[=arg]Setprintingoption'var'to'arg'(seepsetcommand)-qRu

6、nquietly(nomessages,onlyqueryoutput)-RSetrecordseparator(default:newline)(-Precordsep=)-RevShowversioninformationandexit-revShowversioninformationandexit-sSinglestepmode(confirmeachquery)-SSinglelinemode(newlineterminatesquery)-tPrintrowsonly(-Ptuples_only)-Ttex

7、tSetHTMLtabletagoptions(width,border)(-Ptableattr=)-uSpecifydatabaseusername(default:admin)-USpecifydatabaseusername(default:admin)-vname=valSetnzsqlvariable'name'to'value'-VShowversioninformationandexit-WSpecifythedatabaseuserpassword-pw

8、assword>Specifythedatabaseuserpassword-xTurnonexpandedtableoutput(-Pexpanded)-XDonotreadstartupfile(~/.nzsqlrc)-hor-?DisplaythishelpWelcometonzsql,theNetezzaSQLinteractiveterminal.Type:hforhelpwithSQLcommands?forhelponinternalslashcommandsgorterminatewithsemicolontoe

9、xecutequeryqtoquitsystem(admin)=>hAvailablehelp:ALTERGROUPCREATEVIEWROLLBACKALTERTABLEDELETESELECTALTERUSERDROPDATABASESETBEGINDROPGROUPSETSESSIONCOMMENTDROPTABLESETSYSTEMDEFAULTCOMMITDROPUSERSETTRANSACTIONCOPYDROPVIEWSHOWCREATEDATABASEEXPLAINSHOWSYSTEMDEFAULT-Page1of

10、7-CREATEEXTERNALTABLEGENERATESTATISTICSTRUNCATECREATEGROUPGRANTUPDATECREATETABLEINSERTVACUUMCREATETABLEASRESET