Searching multiple columns for a row match in MySQL

AmitDiwan
Published on 25-Aug-2019 06:18:23
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

Properties of a Graph

Mahesh Parahar
Published on 25-Aug-2019 06:18:23
Graphs come with various properties which are used for characterization of graphs depending on their structures. These properties are defined in specific terms pertaining to the domain of graph theory. In this chapter, we will discuss a few basic properties that are common in all graphs.Radius of a Connected GraphThe ... Read More

Graph Fundamentals

Mahesh Parahar
Published on 25-Aug-2019 06:18:23
A graph is a diagram of points and lines connected to the points. It has at least one line joining a set of two vertices with no vertex connecting itself. The concept of graphs in graph theory stands up on some basic terms such as point, line, vertex, edge, degree ... Read More

Concatenate a string in an already created field values set with MySQL TEXT data type

AmitDiwan
Published on 25-Aug-2019 06:18:23
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

Eulerian Graphs

Mahesh Parahar
Published on 25-Aug-2019 06:18:23
Euler Graph - A connected graph G is called an Euler graph, if there is a closed trail which includes every edge of the graph G.Euler Path - An Euler path is a path that uses every edge of a graph exactly once. An Euler path starts and ends at ... Read More

Display records from MySQL stored Procedure with IF…THEN…END IF statements

AmitDiwan
Published on 25-Aug-2019 06:18:23
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

Cardinality of a Set

Mahesh Parahar
Published on 25-Aug-2019 06:18:23
Cardinality of a set S, denoted by |S|, is the number of elements of the set. The number is also referred as the cardinal number. If a set has an infinite number of elements, its cardinality is ∞.Example − |{1, 4, 3, 5}| = 4, |{1, 2, 3, 4, 5, ... Read More

The Graph Coloring

Mahesh Parahar
Published on 25-Aug-2019 06:18:23
Graph coloring is the procedure of assignment of colors to each vertex of a graph G such that no adjacent vertices get same color. The objective is to minimize the number of colors while coloring a graph. The smallest number of colors required to color a graph G is called ... Read More

Get employee name from a specific company using MySQL GROUP BY?

AmitDiwan
Published on 25-Aug-2019 06:18:23
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

Calendar Functions in Python | Set 1( calendar(), month(), isleap()…)

Pradeep Elance
Published on 25-Aug-2019 06:18:23
Handling date through some type of in-built calendar is central to any programming language. Here we see how to handle various date related functions available in python’s in-built library.firstweekday()Using this function we find the number assigned to the first day of the week.Example Live Demoimport calendar # print starting day ... Read More
Previous 1 ... 4 5 6 7 8 9 10 ... 2440 Next
Advertisements