- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Arjun Thakur has Published 1176 Articles
Arjun Thakur
2K+ Views
First, we will create a table and insert some values into the table. Let us create a table. mysql> create table RowValueDemo -> ( -> Name varchar(100) -> ); Query OK, 0 rows affected (0.69 sec) Insert records using ... Read More
Arjun Thakur
4K+ Views
We can use ‘cross join’ without on condition. Cross join gives the result in cartesian product form. For instance, if in one table there are 3 records and another table has 2 records, then the first record will match with all the second table records. Then, the same process will ... Read More
Arjun Thakur
31 Views
The array_product() function calculates the product of the values in an array. It returns the product of values. Syntax array_product(arr) Parameters arr − The specified array. Return The array_product() function returns the product of values in the array. The value is returned as integer or float. ... Read More
Arjun Thakur
3K+ Views
There are five main memory areas which are used to various Java elements. Following is the list of the same. Class Area - This area contains the static members of the class. Method Area - This area contains the method definition and executable code. Heap Area - This area ... Read More
Arjun Thakur
4K+ Views
Initialization When you assign a value to a variable when it is declared, it is called Initialization. Here is an example − int val = 50; For array initialization, you may need a new keyword, whereas to initialize a variable, you do not need it. Instantiation When you ... Read More
Arjun Thakur
497 Views
The count() function counts elements in an array, or properties in an object. It returns the number of elements in an array. Syntax count(arr, mode) Parameters arr − The specified array. mode − Specifies the mode. Possible values are 0 or 1. 0: Do not count all ... Read More
Arjun Thakur
234 Views
Analog Telephone Cores The early telephone networks had analog cores. Frequency division multiplexing (FDM) was used to transmit a number of voice signals over the single line. Twelve calls were multiplexed into a group. Five groups were multiplexed into a supergroup. Digital Telephone Cores The present telephone networks have digital ... Read More
Arjun Thakur
1K+ Views
We can show the result as a comma separated list with the help of the ‘concat()’ function with the parameter ‘, ’. Let us see an example now. Firstly, we will create a table. The CREATE command is used to create a table. mysql> create table CommaSeperateDemo ... Read More
Arjun Thakur
200 Views
Both are engine types. Here is the query by which we can get to know which engine type and tables are being used. Firstly, we will choose the database with the help of USE command − mysql> USE business; Database changed Here is the query through which we ... Read More
Arjun Thakur
143 Views
To change MySQL column definition, we can use modify or change clause with ALTER command. Let us first create a table with a column as ID, with int data type. We will modify the same column name with varchar data type. Creating a table. mysql> create table ModifyColumnDemo ... Read More
To Continue Learning Please Login
Login with Google