In this tutorial, i am going to show you how to secure and change the PHPMyAdmin login access URL in ubuntu apache on aws. You know that, in the ubuntu apache web server, the phpmyadmin login url is located on http://server-ip/phpmyadmin. And security reasons you may want to change it. So in this tutorial, we … Read more
MySQL BETWEEN condition; In this tutorial, i am going to show you how to use between logical operator of MySQL in query with the help of examples. And i will take some example for how to use date between now and days using MySQL between operator. MySQL BETWEEN Condition MySQL BETWEEN operator is a logical … Read more
MySQL: DAYOFWEEK() Function; In this tutorial, i am going to show you what is DAYOFWEEK() function and how to use it with the help of examples. MySQL DAYOFWEEK() Function The DAYOFWEEK() function returns the weekday index for a given date (a number from 1 to 7). Note: 1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday. Syntax of MySQL … Read more
MySQL CURRENT TIMESTAMP Function; In this tutorial, i am going to show you MySQL current timestamp function with the help of examples. Mysql CURRENT_TIMESTAMP() Function In MySQL, the CURRENT_TIMESTAMP returns the current date and time in ‘YYYY-MM-DD HH:MM:SS’ format or YYYYMMDDHHMMSS. uuuuuu format depending on whether numeric or string is used in the function. NOW() and CURRENT_TIMESTAMP() … Read more
MySQL TIMESTAMP() function; In this tutorial, i am going to show you mysql timestamp() function with the help of examples. MySQL TIMESTAMP Function MySQL TIMESTAMP() function is used to return a DateTime value based on the passed argument in the function. Syntax of MySQL TIMESTAMP Function The syntax of this timestamp() function; as follows: TIMESTAMP(expr) … Read more
MySQL NOT BETWEEN operator; Through this tutorial, i am going to show you how to use not between logical operator of MySQL in the query. MySQL NOT BETWEEN Operator The MySQL Not Between Operator returns the rows or records whose values are not between given values or range If you want to fetch or filter data using … Read more
MySQL DAYOFYEAR() function; In this tutorial, i am going to show you MySQL DAYOFYEAR function with the help of examples. MySQL DAYOFYEAR() Function MySQL DAYOFYEAR function is one of the MySQL Date Functions, which returns the day number of the year from the given date. Syntax of MySQL DAYOFYEAR() Function Basic Syntax of DAYOFYEAR() function is: DAYOFYEAR(date) The date … Read more
MySQL CURTIME() function; In this tutorial, i am going to show you MySQL CURTIME() function with the help of examples. MySQL CURTIME() Function CURTIME() function in MySQL is used to check the current time. It returns the current time as a value in ‘hh:mm:ss’ or ‘hhmmss’ format, depending on whether the function is used in a … Read more
MySQL DATE_SUB() function; In this tutorial, i am going to show you how to subtract days, week, month, year, hours, minutes from date or datetime using MySQL date_sub() function. MySQL DATE_SUB() Function DATE_SUB() function in MySQL is used to subtract a specified time or date interval to a specified date and then returns the date. Syntax … Read more
MySQL DATE() function; In this tutorial, i am going to show you how to use MySQL date() functions with the help of examples. And as well as, i will take some example to fetch data from msyql database using mysql date() with queries. MySQL DATE() function MySQL DATE() takes the DATE part out from a … Read more