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 ... 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 ... 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 ... 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'); ... Read More

Let us first create a table −mysql> create table DemoTable643 (ClientId int); Query OK, 0 rows affected (0.86 sec)Insert some records in the table using insert command −mysql> insert into DemoTable643 values(1000); Query OK, 1 row affected (0.19 sec)Display all records from the table using select statement −mysql> select *from ... Read More

Let us first create a table −mysql> create table DemoTable642(    EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, EmployeeName archar(100), EmployeeCompanyNamevarchar(100) ); Query OK, 0 rows affected (0.81 sec)Insert some records in the table using insert command −mysql> insert into DemoTable642(EmployeeName, EmployeeCompanyName) values('John', 'Google'); Query OK, 1 row affected (0.16 ... Read More

Let us first create a table −mysql> create table DemoTable1 (Id int, Name varchar(100)); Query OK, 0 rows affected (0.89 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1 values(100, 'John'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable1 values(110, 'Chris'); Query OK, ... Read More

For this, you need to set AUTO_INCREMENT as 1000 −alter table yourTableName AUTO_INCREMENT = 1000;Let us first create a table −mysql> create table DemoTable639 (    StudentId int PRIMARY KEY,    StudentStartId int AUTO_INCREMENT,    StudentName VARCHAR(50),    INDEX(StudentStartId) ); Query OK, 0 rows affected (0.86 sec)Following is the query ... Read More

For conditions, use IF(). Let us first create a table −mysql> create table DemoTable637    (ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientAge int ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable637(ClientName, ClientAge) values('Chris', 23); Query ... Read More

Let us first create a table −mysql> create table DemoTable635(    EmployeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, EmployeeName varchar(100) ); Query OK, 0 rows affected (1.24 sec)Insert some records in the table using insert command −mysql> insert into DemoTable635(EmployeeName) values('John'); Query OK, 1 row affected (0.20 sec) mysql> insert ... Read More