Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
There are a variety of mathematical series which python can handle gracefully. One such series is a series of repeated digits. Here we take a digit and add it to the next number which has two such digits and again the next number is three such digits and so on. Finally, we calculate the sum of all such numbers in the series.ApproachWe take a digit and convert it to string. Then concatenate two such strings to get the double digit number and keep concatenating to get higher numbers of such digits. Then we implement a recursive function to add all ... 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 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
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
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
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
Let us first create a table −mysql> create table DemoTable629 (StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentSubject text); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable629(StudentSubject) values('MySQL%'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable629(StudentSubject) values('Spring%Hibernate'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable629(StudentSubject) values('%Java'); Query OK, 1 row affected (0.21 sec)Display all records from the table using select statement −mysql> select *from DemoTable629;This will produce the following output −+-----------+------------------+ | StudentId | StudentSubject | +-----------+------------------+ | ... Read More
A Function assigns to each element of a set, exactly one element of a related set. Functions find their application in various fields like representation of the computational complexity of algorithms, counting objects, study of sequences and strings, to name a few. The third and final chapter of this part highlights the important aspects of functions.Function - DefinitionA function or mapping (Defined as f: X → Y) is a relationship from elements of one set X to elements of another set Y (X and Y are non-empty sets). X is called Domain and Y is called Codomain of function ‘f’.Function ... Read More