Learn MySQL by WAGmob

Giới Thiệu · Learn MySQL by WAGmob

WAGmob brings you Simple 'n Easy, on-the-go learning app for "Learn MySQL". The app provides: 1. Snack sized chapters for easy learning. 2. Bite sized flashcards to memorize key concepts. 3. Simple and easy quizzes for self-assessment. Designed for both students and adults. This app provides a quick summary of essential concepts in MySQL by following snack sized chapters: (Chapters has corresponding flashcards and quizzes)IntroductionWhat is a Database?What is RDBMS?RDBMS TerminologyMySQL DatabaseInstallation on Windows OSDownloading MySQLMySQL InstallerHardware RequirementsSoftware RequirementsInstalling MySQL Workbench on WindowsLaunching MySQL Workbench on WindowsGetting Started TutorialPHP SyntaxMySQL + PHPOpening a ConnectionClosing a ConnectionGeneric MySQL PHP SyntaxCREATE DatabaseWho can create a Database?Create Database using mysqladmin toolCREATE Database using PHP ScriptSelecting DatabaseSelecting MySQL Database from Command PromptSelecting MySQL Database Using PHP ScriptData typeMySQL Data typesNumeric Data TypesDate and Time TypesString TypesMySQL TableMySQL CREATE TablesCREATE TABLE from Command PromptCREATE TABLE Using PHP ScriptDROP TABLEDROP MySQL TablesDROP TABLE from Command PromptDROP TABLE using PHP ScriptINSERT QueryMySQL INSERT INTO QueryINSERT from Command PromptINSERT Using PHP ScriptSELECT QueryMySQL SELECT QueryKey Points for SELECT CommandFetching Data from Command PromptFetching Data Using PHP ScriptWHERE ClauseMySQL WHERE ClauseFetching Data from Command PromptFetching Data using PHP ScriptUPDATE QueryMySQL UPDATE QueryUpdating Data from Command PromptUpdating Data Using PHP ScriptDELETE QueryMySQL DELETE QueryDeleting Data from Command PromptDeleting Data Using PHP ScriptLIKE ClauseMySQL LIKE ClauseWhen do we need LIKE Clause?Using LIKE clause at Command PromptUsing LIKE clause inside PHP ScriptSORTING ResultsSorting in MySQL DatabaseThe ORDER BY ClauseUsing ORDER BY clause at Command PromptUsing ORDER BY clause inside PHP ScriptJOINSJOINS in MySQLUsing JOINS at Command PromptUsing JOINS in PHP ScriptMySQL LEFT JOINNULL ValueHandling MySQL NULL ValuesUsing NULL values at Command PromptHandling NULL Values in PHP ScriptSummary - FunctionsString Functions in MySQLNumeric Functions in MySQLSummary - OperatorsMySQL OperatorsSummary Data types and KeywordsData typesKeywordsSample SELECT QueriesSample QueriesAbout WAGmob apps:1) A companion app for on-the-go, bite-sized learning.2) Offers value for money (a lifetime of free updates).3) Over One million paying customers from 175+ countries.WAGmob Vision : Simple 'n easy apps for a lifetime of on-the-go learningVisit us: www.wagmob.comPlease write to us at Team@WAGmob.com. We would love to improve this app.Content rating: Everyone