Teachnique
      CourseRoadmaps
      Login

      HomeIntroductionFeaturesVersionsVariablesInstallationAdministrationPHP SyntaxNode.js SyntaxJava SyntaxPython SyntaxConnectionWorkbench

      Create DatabaseDrop DatabaseSelect DatabaseShow DatabaseCopy DatabaseDatabase ExportDatabase ImportDatabase Info

      Create UsersDrop UsersShow UsersChange PasswordGrant PrivilegesShow PrivilegesRevoke PrivilegesLock User AccountUnlock User Account

      Create TablesShow TablesAlter TablesRename TablesClone TablesTruncate TablesTemporary TablesRepair TablesDescribe TablesAdd/Delete ColumnsShow ColumnsRename ColumnsTable LockingDrop TablesDerived Tables

      QueriesConstraintsInsert QuerySelect QueryUpdate QueryDelete QueryReplace QueryInsert IgnoreInsert on Duplicate Key UpdateInsert Into Select

      Create ViewsUpdate ViewsDrop ViewsRename Views

      IndexesCreate IndexDrop IndexShow IndexesUnique IndexClustered IndexNon-Clustered Index

      Where ClauseLimit ClauseDistinct ClauseOrder By ClauseGroup By ClauseHaving ClauseAND OperatorOR OperatorLike OperatorIN OperatorANY OperatorEXISTS OperatorNOT OperatorNOT EQUAL OperatorIS NULL OperatorIS NOT NULL OperatorBetween OperatorUNION OperatorUNION vs UNION ALLMINUS OperatorINTERSECT OperatorINTERVAL Operator

      Using JoinsInner JoinLeft JoinRight JoinCross JoinFull JoinSelf JoinDelete JoinUpdate JoinUnion vs Join

      Unique KeyPrimary KeyForeign KeyComposite KeyAlternate Key

      TriggersCreate TriggerShow TriggerDrop TriggerBefore Insert TriggerAfter Insert TriggerBefore Update TriggerAfter Update TriggerBefore Delete TriggerAfter Delete Trigger

      Data TypesVARCHARBOOLEANENUMDECIMALINTFLOATBITTINYINTBLOBSET

      Regular ExpressionsRLIKE OperatorNOT LIKE OperatorNOT REGEXP Operatorregexp_instr() Functionregexp_like() Functionregexp_replace() Functionregexp_substr() Function

      Fulltext SearchNatural Language Fulltext SearchBoolean Fulltext SearchQuery Expansion Fulltext Searchngram Fulltext Parser

      Date and Time FunctionsArithmetic OperatorsNumeric FunctionsString FunctionsAggregate Functions

      NULL ValuesTransactionsUsing SequencesHandling DuplicatesSQL InjectionSubQueryCommentsCheck ConstraintsStorage EnginesExport Table into CSV FileImport CSV File into DatabaseUUIDCommon Table ExpressionsOn Delete CascadeUpsertHorizontal PartitioningVertical PartitioningCursorStored FunctionsSignalResignalCharacter SetCollationWildcardsAliasROLLUPToday DateLiteralsStored ProcedureExplainJSONStandard DeviationFind Duplicate RecordsDelete Duplicate RecordsSelect Random RecordsShow ProcesslistChange Column TypeReset Auto-IncrementCoalesce() Function

      Useful FunctionsStatements ReferenceQuick GuideUseful ResourcesDiscussion

      Feedback

      Submit request if you have any questions.

      Course
      Installation

      MySQL Tutorial

      This SQL tutorial is structured for beginners to guide them from the foundational concepts to advanced data manipulation and querying techniques in SQL. By the end of this tutorial, you will have developed a robust understanding of SQL, equipping you with the knowledge to efficiently manage and analyze data across various database systems. This guide sets the stage for your growth into a skilled data professional, ready to tackle complex data challenges and contribute to the field of data analysis and database management.

      Installation

      All downloads for MySQL are located at MySQL Downloads. Pick the version number of MySQL Community Server which is required along with the platform you will be running it on.

      Installing MySQL on Windows

      In this tutorial, we are installing the latest version of MySQL (8.0.34) on Windows 11. Follow the given steps to do so
      Step 1: Firstly, choose the MySQL version and operating system. Then, we download the desired MSI installer on your system by clicking the 'Download' button shown in the image below. This installer is suitable for both 32-bit and 64-bit systems.
      
      Step 2: Then, we will be redirected to another file download page. Here, ignore the prompts asking to log in or sign up and directly start downloading by clicking on the link as shown in the image.
      
      Step 3: Once the installer is downloaded, run it to start the MySQL installation.
      Step 4: Now, we can see the installer community window, asking to choose a Setup type for our MySQL products. Choose Custom and click Next to decide what products we want to actually install.
      
      Step 5: In the next step, select MySQL Server, MySQL Workbench, MySQL Shell (all latest versions) to be installed. We can also choose more products available as per necessity. Click Next.
      
      Step 6: The installation process will now begin. However, path conflicts might arise if there exists a path directory with the same name. After the installation is done, click Next.
      
      Step 7: In this step, we will be asked to set Type and Networking of MySQL. Unless there is any particular change we want to make, it is recommended to keep the settings as they are, and click Next.
      
      Step 8: Then, we need to set the Authentication method to access MySQL root user. So, choose the strong password encryption method (as it is recommended) and click Next.
      
      Step 9: Set a password for the root account. This password must always be used to log into the root account in every session. After setting password, click Next.
      
      Step 10: In this step, MySQL Server Instance will be configured as a Windows Service. The default name will be set as "MySQL80", which can be changed if needed. Click Next.
      
      Step 11: Now, set the file permissions as required and click Next.
      
      Step 12: As shown in the image below, the specified configuration steps will be applied on clicking Execute.
      
      Once it is completed, click Finish. The next window will display the products on which the configuration is applied. Click Next to finish the installation.
      
      Step 12: The installation is now complete. Uncheck the options asking to start MySQL Workbench and Shell after setup, so that they will not run after setup. Click Finish.
      
      The MySQL Server is now installed in the Windows Operating System. We can now access it via the Command Prompt or the UI products we installed with it (Shell and Workbench).

      Installing MySQL on Linux/UNIX

      The recommended way to install MySQL on a Linux system is via RPM. MySQL AB makes the following RPMs available for download on its website
      • MySQL − The MySQL database server manages the databases and tables, controls user access and processes the SQL queries.
      • MySQL-client − MySQL client programs, which make it possible to connect to and interact with the server.
      • MySQL-devel − Libraries and header files that come in handy when compiling other programs that use MySQL.
      • MySQL-shared − Shared libraries for the MySQL client.
      • MySQL-bench − Benchmark and performance testing tools for the MySQL database server.
      The MySQL RPMs listed here are all built on a SuSE Linux system, but they will usually work on other Linux variants with no difficulty.
      Now, you will need to adhere to the steps given below, to proceed with the installation
      • Login to the system using the root user.
      • Switch to the directory containing the RPMs.
      • Install the MySQL database server by executing the following command. Remember to replace the filename in italics with the file name of your RPM.
      [root@host]# rpm -i MySQL-5.0.9-0.i386.rpm
      The above command takes care of installing the MySQL server, creating a user of MySQL, creating necessary configuration and starting the MySQL server automatically.
      You can find all the MySQL related binaries in /usr/bin and /usr/sbin. All the tables and databases will be created in the /var/lib/mysql directory.
      The following code box has an optional but recommended step to install the remaining RPMs in the same manner 
      [root@host]# rpm -i MySQL-client-5.0.9-0.i386.rpm
      [root@host]# rpm -i MySQL-devel-5.0.9-0.i386.rpm
      [root@host]# rpm -i MySQL-shared-5.0.9-0.i386.rpm
      [root@host]# rpm -i MySQL-bench-5.0.9-0.i386.rpm