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
      Today Date

      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.

       Today Date

      Generally, the date is represented using three values: date, month, and year. Dates have many possible variations, all of which depend on several inconsistency factors.
      • DD/MM/YYYY, For instance - 04/04/2024
      • YYYY/MM/DD, For instance - 2024/04/27
      • DD-MM-YYYY, For instance - 04-04-2024

      MySQL Today's Date

      We have several built-in functions to retrieve and manipulate the MySQL today's date. The following are the functions: CURDATE(), CURRENT_DATE(), CURRENT_DATE.
      CURDATE(): This function returns the current date as ‘YYYY-MM-DD’ (string) or ‘YYYYMMDD’ (numeric).
      CURRENT_DATE(): This function is s synonym to the CURDATE() function which returns the current date in the same format.
      CURRENT_DATE: This is also synonym of CURDATE() function.

      MySQL CURDATE() Function

      In the following example, we are retrieving the current date value using the CURDATE() function
      
      SELECT CURDATE() AS Today;

      Output

      On executing the given query, the output is displayed as follows
      Today
      2023-04-27

      MySQL CURRENT_DATE() Function

      Similarly, we can also display the current date value using the CURRENT_DATE() function.
      SELECT CURRENT_DATE() AS Today;

      Output

      On executing the given query, the output is displayed as follows
      Today
      2023-04-27

      MySQL CURRENT_DATE Function

      In this example, we use the CURRENT_DATE function to retrieve the current date local to a system.
      SELECT CURRENT_DATE AS Today;

      Output

      On executing the given query, the output is displayed as follows
      Today
      2023-04-27

      Inserting Date Values in a Table

      Following are the steps to insert date and time values in a table
      • First, we must create a table that accepts date and time values.
      • Second, we must insert the data into the newly created table, which accepts date and time data types.

      Example

      Now, let us a create a table with the name ORDERS using the following query 
      CREATE TABLE ORDERS (
         OID INT NOT NULL,
         DATE VARCHAR (20) NOT NULL,
         CUSTOMER_ID INT NOT NULL,
         AMOUNT DECIMAL (18, 2)
      );
      Here, we are inserting values into the above-created table using the INSERT INTO statement as shown below 
      INSERT INTO ORDERS VALUES 
      (102, CURDATE() + 1, 3, 3000.00),
      (100, CURDATE() - 5, 3, 1500.00),
      (101, CURRENT_DATE() - 2, 2, 1560.00),
      (103, CURRENT_DATE + 3, 4, 2060.00);
      The table is created as follows
      OID
      DATE
      CUSTOMER_ID
      AMOUNT
      102
      20231012
      3
      3000.00
      100
      20231006
      3
      1500.00
      101
      20231009
      2
      1560.00
      103
      20231014
      4
      2060.00

      Today Date Using Client Program

      We can also perform Today Date Using Client Program.

      Syntax

      PHPNodeJSJavaPython
      To display today date through a PHP program use CURDATE() function, we need to execute the "SELECT" statement using the mysqli function query() as follows 
      $sql = "SELECT CURRENT_DATE AS TODAYS_DATE";
      $mysqli->query($sql);

      Example

      Following are the programs
      PHPNodeJSJavaPython
      $dbhost = 'localhost';
      $dbuser = 'root';
      $dbpass = 'password';
      $db = 'TUTORIALS';
      $mysqli = new mysqli($dbhost, $dbuser, $dbpass, $db);
      if ($mysqli->connect_errno) {
          printf("Connect failed: %s", $mysqli->connect_error);
          exit();
      }
      //printf('Connected successfully.');
      $sql = "SELECT CURRENT_DATE AS TODAYS_DATE";
      If($result = $mysqli->query($sql)){
          printf("Select query executed successfully...!\n");
          while($row = mysqli_fetch_array($result)){
              printf("Todays date: %s", $row["TODAYS_DATE"]);
          }
      }
      if($mysqli->error){
          printf("Error message: ", $mysqli->error);
      }
      $mysqli->close();

      Output

      The output obtained is as shown below 
      Select query executed successfully...!
      Todays date: 2023-08-04