Ankith Reddy has Published 996 Articles

Usage of CSS table-layout property

Ankith Reddy

Ankith Reddy

Updated on 31-Jan-2020 10:07:41

83 Views

The table-layout property is to help you control how a browser should render or lay out a table. This property can have one of the three values: fixed, auto or inherit.ExampleYou can try to run the following code to implement CSS table-layout property               ... Read More

Create a transparent image with CSS

Ankith Reddy

Ankith Reddy

Updated on 31-Jan-2020 06:57:33

216 Views

To create a transparent image, use the CSS -moz-opacity property. You can try to run the following code to style an image and set opacity with CSS:Example                      

Usage of height property with CSS

Ankith Reddy

Ankith Reddy

Updated on 31-Jan-2020 06:53:26

134 Views

The height property is used to set the height of an image. This property can have a value in length or in %. While giving value in %, it applies it in respect of the box in which an image is available.ExampleYou can try to run the following code to set ... Read More

How can we know the repetition of a value in column with the help of group function COUNT(*) and GROUP BY clause?

Ankith Reddy

Ankith Reddy

Updated on 30-Jan-2020 05:48:55

169 Views

We can use COUNT(*) and GROUP BY clause to find out the repetition of a value in the column. Following is the example, using COUNT(*) and GROUP BY clause on ‘Name’ column of table ‘Student’, to demonstrate it −mysql> select count(*), name from student group by name; +----------+---------+ | ... Read More

How can we fetch one or more columns as output from a MySQL table?

Ankith Reddy

Ankith Reddy

Updated on 29-Jan-2020 06:33:57

289 Views

The SELECT command can be used to fetch one or more columns as output from MySQL table. An  example is given below to fetch one or more columnsmysql> Select * from Student; +------+---------+---------+-----------+ | Id   | Name    | Address | Subject   | +------+---------+---------+-----------+ | 1    | ... Read More

What is the concept of CTAS (CREATE TABLE AS SELECTED) in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 29-Jan-2020 06:20:13

680 Views

CTAS i.e. “Create Table AS Select” script is used to create a table from an existing table. It copies the table structure as well as data from the existing table. Consider the following example in which we have created a table named EMP_BACKUP from an already existing table named ‘Employee’mysql> ... Read More

How can we get more details about columns of an existing table than return by MySQL SHOW COLUMNS statement?

Ankith Reddy

Ankith Reddy

Updated on 29-Jan-2020 05:29:08

166 Views

If we want to get more details about the column of an existing table then we need to use SHOW FULL COLUMNS statement. Consider the example below in which SHOW FULL COLUMNS statement has been applied on ‘Employee’ table and MySQL returns result set with some extra details like Collation, ... Read More

What is the way to check the size of all the MySQL databases?

Ankith Reddy

Ankith Reddy

Updated on 28-Jan-2020 10:56:05

122 Views

We can check the size of all MySQL databases with the help of the following statementmysql> SELECT table_schema "Database", -> SUM(data_length + index_length)/1024/1024 "Size in MB" -> FROM information_schema.TABLES GROUP BY table_schema; +--------------------+----------------+ | Database           | Size in MB     | +--------------------+----------------+ | ... Read More

How to add picasso library in android studio?

Ankith Reddy

Ankith Reddy

Updated on 27-Jan-2020 13:10:23

1K+ Views

Before getting into picasso library example, we should know about picasso. Picasso is image processing library and developed by Square Inc. In older days we used to write lengthy of codes to grab image from server or do process., to optimize the process picasso introduced.This example demonstrate about how to ... Read More

World Map on HTML5 Canvas or SVG

Ankith Reddy

Ankith Reddy

Updated on 27-Jan-2020 07:05:11

775 Views

You can use SVG to create a World Map and work with raphaeljs.Firstly, learn how to add Raphael.js, and create a circle, var paper = Raphael(10, 50, 320, 200); // drawing circls var circle = paper.circle(50, 40, 10); circle.attr("fill", "#f00"); circle.attr("stroke", "#fff");Then refer the following to create a ... Read More

Advertisements