MySQL Tutorial

MySQL WEEKOFYEAR() Function

by

MySQL WEEKOFYEAR() function; Through this tutorial, i am going to show you MySQL WEEKOFYEAR() function with the help of examples. MySQL WEEKOFYEAR() Function WEEKOFYEAR() function in MySQL is used to find the week number for a given date. If the date is NULL, the WEEKOFYEAR function will return NULL. Otherwise, it returns the value of week … Read more

MySQL LOCALTIMESTAMP() Function

by

MySQL LOCALTIMESTAMP() function; In this tutorial, i am going to show you MySQL LOCALTIMESTAMP() function with the help of examples. Mysql LOCALTIMESTAMP() Function MySQL LOCALTIMESTAMP() function is used to return the current date and time in the format of “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS. Syntax of Mysql LOCALTIMESTAMP() Function The basic syntax of this function is: … Read more

MySQL Delete Duplicate Rows but keep one

by

Find and delete duplicate records into MySQL database; In this tutorial, i am going to show you how to find and delete duplicate records or rows in the database table but keep ones into MySQL database table. Find and Delete duplicate records in MySQL Use the following methods to find and delete duplicate records or … Read more

PHPMyAdmin Access Denied for user ‘root’@’localhost’ Ubuntu

by

This is a very common issue whenever a user installs and configures a new MySQL. Then user has to face the problem, Which is Can’t log into phpMyAdmin: mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’. This error message usually appears for new installations of MySQL when you try to login in PHPmyadmin with the root user. But in … Read more

MySQL CURDATE Function

by

MySQL CURDATE() function; In this tutorial, i am going to show you what is MySQL curdate() function and how to use CURDATE() MySQLwith the help of the examples. MySQL CURDATE Function MySQLCURDATE() function returns the present date in various formats, such as ‘YYYY-MM-DD’ or ‘YYYYMMDD’ format, depending on whether the numerical or string is used … Read more

Mysql Get Current Date, Week, Month, YEAR Data

by

Mysql get current date, week, month, year data; Through this tutorial, i am going to show you how to get current date, current week, current, month, current year data in MySQL. How to Get Data Of Current Date, Week, Month, YEAR in MySQL Use the following MySQL queries to get data of current date, week, … Read more

MySQL MAKEDATE() Function

by

MySQL MAKEDATE() function; In this tutorial, i am going to show you MySQL MAKEDATE() function with the help of examples. MySQL MAKEDATE() Function The MySQL makedate() function is used to create and return a date based on a year and a number of days value. The number of days must be greater than 0 otherwise it … Read more

MySQL Time() Function

by

MySQL time() function; In this tutorial, i am going to show you MySQL time() functions with the help of examples. MySQL time() Function The TIME() function extracts the time part from a given time/datetime. Syntax of MySQL time() Function TIME(DateTime/Time) Here, DateTime/Time:- It is a required. Example 1 – MySQL time() Function Let’s take the first example … Read more

Create, Alter, Drop, Truncate, View in MySQL Table

by

Create, alter, drop, truncate and view in MySQL table; Through this tutorial, i am going to show you MySQL statements such as Create Table, Alter Table, Drop Table, Truncate Table, Create Views Table, Drop views table & Update views table and it’s usage. MySQL Table Create, Alter, Drop, Truncate, View Use the following MySQL statements … Read more