Here, we are converting time value, for example 150:50:10 to days and hours form, i.e. 6 days 6 hours.You can use CONCAT() along with HOUR() for this. Let us first create a table −mysql> create table DemoTable657(DueTime time); Query OK, 0 rows affected (3.68 sec)Insert some records in the table using insert command. Here, we have inserted the records in the form of total hours −mysql> insert into DemoTable657 values('120:30:00'); Query OK, 1 row affected (0.38 sec) mysql> insert into DemoTable657 values('150:50:10'); Query OK, 1 row affected (0.27 sec)Display all records from the table using select statement −mysql> select *from ... Read More

You can use SELECT *FROM yourTableName in stored procedure. Let us first create a table −mysql> create table DemoTable654 (    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(100) ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table using insert command −mysql> insert into DemoTable654(StudentFirstName) values('John'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable654(StudentFirstName) values('Sam'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable654(StudentFirstName) values('Mike'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable654(StudentFirstName) values('Robert'); Query OK, 1 row affected (0.12 sec)Display all records from the table using ... Read More

To change order of items in MySQL, use ORDER BY alias name. Let us first create a table −mysql> create table DemoTable653 (Product1Amount int, Product2Amount int); Query OK, 0 rows affected (0.42 sec)Insert some records in the table using insert command −mysql> insert into DemoTable653 values(400, 250); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable653 values(500, 300); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable653 values(40, 400); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable653 values(200, 450); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable653 values(50, 20); Query ... Read More

Let us first create a table −mysql> create table DemoTable651 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value varchar(100)); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable651(Value) values('Title'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable651(Value) values('course'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable651(Value) values('subject'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> select *from DemoTable651;This will produce the following output −+----+---------+ | Id | Value | +----+---------+ | 1 | ... Read More

For this, use aggregate function COUNT(). Let us first create a table −mysql> create table DemoTable650 (Value1 int, Value2 int); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable650 values(200, 500); Query OK, 1 row affected (0.12 sec)Display ... Read More

Let us first create a table −mysql> create table DemoTable649 (Value text); Query OK, 0 rows affected (0.68 sec)Insert some records in the table using insert command −mysql> insert into DemoTable649 values('1903'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable649 values('9321010'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable649 values('983032023393'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable649 values('1234567892'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable649 values('989898989'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> select *from DemoTable649;This will ... Read More

Let us first create a table. One of the columns is set as TIMESTAMP −mysql> create table DemoTable648(    UserId int NOT NULL AUTO_INCREMENT, UserLoginTime TIMESTAMP NOT NULL    DEFAULT CURRENT_TIMESTAMP, PRIMARYKEY(UserId) ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command. Here, we have set the current date and time to timestamp column using the NOW() method −mysql> insert into DemoTable648(UserLoginTime) values(NOW()); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement −mysql> select *from DemoTable648;This will produce the following output −+--------+---------------------+ | UserId | UserLoginTime     ... Read More

Use RAND() for random, whereas LIMIT 3 for the number of values i.e. 3 here −select yourColumnName from yourTableName order by rand() limit 3;Let us first create a table −mysql> create table DemoTable646 (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName varchar(100) ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable646(FirstName) values('John'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable646(FirstName) values('Bob'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable646(FirstName) values('Chris'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable646(FirstName) ... Read More

For this, use UNION. Let us first create a table −mysql> create table DemoTable645 (Id int, FirstName varchar(100)); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable645 values(100, 'Chris'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable645 values(101, 'Robert'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable645 values(101, 'Bob'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable645 values(102, 'Carol'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable645 values(100, 'John'); Query OK, 1 row affected (0.12 sec) mysql> insert ... Read More

For this, use CONCAT(). Let us first create a table −mysql> create table DemoTable644 (Title text); Query OK, 0 rows affected (0.81 sec)Insert some records in the table using insert command −mysql> insert into DemoTable644 values('Introduction'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable644 values('Welcome in course'); Query OK, 1 row affected (0.10 sec)Display all records from the table using select statement −mysql> select *from DemoTable644;This will produce the following output −+-------------------+ | Title          | +-------------------+ | Introduction    | | Welcome in course | +-------------------+ 2 rows ... Read More