mysql-tutorial-excerpt-5.1-en.pdf

《mysql-tutorial-excerpt-5.1-en.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、MySQLTutorialMySQLTutorialAbstractThisistheMySQLTutorialfromtheMySQL5.1ReferenceManual.Documentgeneratedon:2014-01-22(revision:37462)TableofContentsPrefaceandLegalNotices........................................................................................

2、..........................v1Tutorial...........................................................................................................................................12ConnectingtoandDisconnectingfromtheServer........................................

3、.....................................33EnteringQueries.............................................................................................................................54CreatingandUsingaDatabase....................................................

4、...................................................94.1CreatingandSelectingaDatabase.....................................................................................104.2CreatingaTable......................................................................

5、...........................................114.3LoadingDataintoaTable...................................................................................................124.4RetrievingInformationfromaTable......................................................

6、...............................134.4.1SelectingAllData....................................................................................................144.4.2SelectingParticularRows..........................................................................

7、...............144.4.3SelectingParticularColumns....................................................................................154.4.4SortingRows...........................................................................................................1

8、74.4.5DateCalculations.....................................................................................................184.4.6WorkingwithNULLValues...........................................