mysql

Creating and Selecting a Database

January 1, 2019 Manisha Patel Creating and Selecting a Database, Creating and Selecting a Database command line, Creating and Selecting a Database from cli, MySQL, mysql query to create database, mysql query to select database

Creating and Selecting a Database If the database administrator creates your database for you when setting up your permissions, you

mysql

SQL CASE

January 1, 2019 Manisha Patel case example in mysql, CASE WHEN Quantity > 30 THEN "The quantity is greater than 30" WHEN Quantity = 30 THEN "The quantity is 30" ELSE "The quantity is under 30" END AS QuantityText FROM OrderDetails;, MySQL, mysql case statement, Quantity, SELECT OrderID, SQL CASE

SQL CASE The CASE statement goes through conditions and return a value when the first condition is met (like an

mysql Tutorial

Rename database in MySQL

December 29, 2018 eduguru 0 Comments database rename, db rename in mysql, How to Rename database in MySQL, MySQL, mysql db rename, Rename database in MySQL

From phpMyAdmin, select the database you want to select. In the tabs there’s one called Operations, go to the rename

infographics

mysql between example : Get data between two dates

December 27, 2018 Manisha Patel between in mysql, MySQL, mysql between example, mysql between example : Get data between two dates, select data between two dates mysql

mysql between example : Get data between two dates

mysql

comparison operator between in mysql

December 27, 2018 Manisha Patel between, comparison operator between in mysql, MySQL, mysql between function, mysql between operator, mysql comparison operator, mysql not between, mysql not in between

comparison operator between in mysql General Syntax – mostly used SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; expr BETWEEN min AND max If expr

mysql

get the difference between two timestamps in seconds

December 26, 2018 eduguru difference between two time in mysql in seconds, get the difference between two timestamps in seconds, how to get the difference between two timestamps in seconds, MySQL, mysql time difference, mysql timstamp difference of two time, time difference in second in mysql

get the difference between two timestamps in seconds You could use the TIMEDIFF() and the TIME_TO_SEC() functions as follows: SELECT TIME_TO_SEC(TIMEDIFF(‘2010-08-20 12:01:00’, ‘2010-08-20

mysql

mysql length function : calculate length of a column

December 8, 2018 eduguru LENGTH(CustomerName) AS LengthOfName FROM Customers;, MySQL, mysql calculate length of a column, mysql len function, mysql length function, mysql length function : calculate length of a column, mysql select length, Return the length of the string, SELECT CustomerName

mysql length function : calculate length of a column Function length() Return the length of the string Usages SELECT CustomerName,

mysql

Install mysql on centos linux

October 31, 2018 eduguru how to install mysql, Install mysql on centos linux, installation of mysql, learn mysql, mysql install, mysql o centos, mysql secure installation, secure installation mysql

Install mysql on centos linux Reference : https://blog.eduguru.in/linux-2/install-lamp-server-apache-mysql-php-on-rhel-centos-scientific-linux-6-56-4 Install MySQL MySQL is an enterprise class, open source, world’s second most used

mysql

MySQL conditional expression CASE

October 30, 2018 eduguru case in mysql, case query mysql, case when in mysql, conditional query in mysql, learn mysql, MySQL, mysql case condition, mysql case expression, mysql case statement, mysql conditional expression, MySQL conditional expression CASE, mysql query case when

MySQL conditional expression CASE MySQL CASE expression is a conditional expression that allows you to construct conditions inside a query such as SELECT or WHERE

infographics mysql

mysql – sql query to fetch count of employee

September 15, 2018 Manisha Patel 0 Comments learn how to write query, learn mysql query, MySQL, mysql - sql query to fetch count of employee, mysql query, sql query, write mysql query

mysql – sql query to fetch count of employee