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 to set auto increment with value 1000 −mysql> alter table DemoTable639 AUTO_INCREMENT = 1000; Query OK, 0 rows affected (0.28 sec) Records: 0 Duplicates: 0 Warnings: 0Insert some records in the table using insert command −mysql> insert into DemoTable639(StudentId, StudentName) values(1, 'John'); Query OK, 1 row affected (0.17 sec) mysql> ... Read More

Let us first create a table −mysql> create table DemoTable638 (Name varchar(100), Marks int); Query OK, 0 rows affected (0.68 sec)Insert some records in the table using insert command −mysql> insert into DemoTable638 values('John', 67); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable638 values('John', 90); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable638 values('David', 99); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable638 values('John', 60); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable638;This will produce the following output −+-------+-------+ | ... 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 OK, 1 row affected (0.17 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('Robert', 24); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('David', 57); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('Carol', 60); Query OK, 1 row affected (0.13 sec)Display all records ... Read More

For this, you can use aggregate function SUM(). Let us first create a table −mysql> create table DemoTable636 (    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(100) ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable636(StudentFirstName) values('John'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable636(StudentFirstName) values('Robert'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable636(StudentFirstName) values('Robert'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable636(StudentFirstName) values('Sam'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable636(StudentFirstName) values('Mike'); Query OK, ... 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 into DemoTable635(EmployeeName) values('Sam'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable635(EmployeeName) values(''); Query OK, 1 row affected (0.38 sec) mysql> insert into DemoTable635(EmployeeName) values(null); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable635(EmployeeName) values('David'); Query OK, 1 row affected (0.22 sec)Display all records from the ... Read More

For this, use FIND_IN_SET() method. Let us first create a table −mysql> create table DemoTable634 (FirstName varchar(100), Marks int, Age int); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable634 values('John', 60, 23); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable634 values('Chris', 80, 21); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable634 values('Robert', 70, 24); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement −mysql> select *from DemoTable634;This will produce the following output −+-----------+-------+------+ | FirstName | Marks ... Read More

Let us first create a table −mysql> create table DemoTable633 (StudentId char(2) not null primary key, StudentName varchar(100)); Query OK, 0 rows affected (1.06 sec)Insert some records in the table using insert command −mysql> insert into DemoTable633 values('10', 'Chris'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable633 values('20', 'Sam'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable633 values('30', 'David'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select *from DemoTable633;This will produce the following output −+-----------+-------------+ | StudentId | StudentName | +-----------+-------------+ | 10     ... Read More

For negative values, use reverse() along with concat(). Let us first create a table −mysql> create table DemoTable632 (    histogramId int NOT NULL AUTO_INCREMENT PRIMARY KEY, histogramValue int, histogramImage text ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table using insert command −mysql> insert into DemoTable632(histogramValue) values(2); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable632(histogramValue) values(3); Query OK, 1 row affected (0.34 sec) mysql> insert into DemoTable632(histogramValue) values(-6); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable632(histogramValue) values(-5); Query OK, 1 row affected (0.13 sec)Display all records from the table ... Read More

Let us first create a table −mysql> create table DemoTable631 (    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentName varchar(100) ); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable631(StudentName) values('John Smith'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable631(StudentName) values('Adam Smith'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable631(StudentName) values('David Miller'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable631;This will produce the following output −+-----------+--------------+ | StudentId | StudentName | ... Read More

Let us first create a table −mysql> create table DemoTable630 (ArrivalDate varchar(100)); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command −mysql> insert into DemoTable630 values('2015-21-01'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable630 values('2018-25-12'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable630 values('2019-15-07'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable630 values('2016-31-03'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select *from DemoTable630;This will produce the following output −+-------------+ | ArrivalDate | +-------------+ | 2015-21-01  | ... Read More