Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
In order to install MySQL command line client for Windows, you need to visit the following URL to get the download link https://dev.mysql.com/downloads/mysql/ −The snapshot is as follows −After that you need to select operating system. The snapshot is as follows −You need to choose Windows (x86, 32/64-bit) and download the installer.
This is a common issue that has been faced by us once or more in our college and school time. The appropriate resolution for this differs as to which university or organization one studies in. Still, the below solutions could help.1. If carrying a mobile phone is allowed in your library, click a picture of the important topics you wished to study from the book you want to get issued.2. You may also get these books issued on the card of any other student. We used to have the books issued through identity cards in our school and college. In ... Read More
If you will install MySQL on your system, then you will get the default MySQL server port number i.e. 3306.To know the MySQL server port number, you can use the following query. Here, we have used the SHOW VARIABLES command. The query is as follows −mysql> SHOW VARIABLES WHERE Variable_Name = 'port';The following is the output −+---------------+-------+ | Variable_Name | Value | +---------------+-------+ | port | 3306 | +---------------+-------+ 1 row in set (0.04 sec)
To change the default charset of a MySQL table, you can use the below syntax. The syntax is as follows −alter table yourTableName convert to character set yourCharsetName;Let us create a table and apply the above syntax to change the default charset. The query to create a table −mysql> create table CharsetDemo -> ( -> Id int, -> Name varchar(200), -> Age int -> ); Query OK, 0 rows affected (0.73 sec)Now you can change the charset of a table. The following is the query ... Read More
To select MySQL based on month and year, use in-built function YEAR() and MONTH(). The syntax is as follows −select *from yourTableName where YEAR(yourColumnName) = YearValue AND MONTH(yourColumnName) = monthValue;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table selectDataOnYearandMonthDemo −> ( −> BookId int, −> BookName varchar(100), −> BookDueDate datetime −> ); Query OK, 0 rows affected (0.57 sec)Now you can insert some records in the table. The query is as ... Read More
Social reputation is a common desire for every human being. Having lived in a society, any person acquires some reputation depending on the behavior, etiquettes, profession, maintenance, nature etc. from the people around him. When we refer to a group of people who belong to a certain community, they usually form societies and communities and plan activities as we witness in social media daily, to increase their social reputation. Such activities often involve social causes.Scientific Community PeoplePeople who took science as their profession, especially Scientists, researchers, scholars etc. can be referred to as Scientific Community people. Unlike normal people, they ... Read More
Personification is the attributing of human characteristics, thoughts, or emotions to something that is non-human. It is a rhetoric device that is used to convey something more than a literary meaning of a sentence.Example: The heavens wept at the incident.Now, in this sentence, heavens cannot weep but the idea of emotions and weeping is produced through “wept”. Heaven is non-living and it is weeping just like humans do. Hence, the sentence features personification.Example: The thunder clapped angrily from a distance.Definitely, the thunder cannot clap. It is a non-living thing but the writer wants to convey the intensity of clapping by ... Read More
To check how many users are present in MySQL, use MySQL.user table. The syntax is as follows to check how many users are present.mysql> SELECT User FROM mysql.user;The following output displays the users −+------------------+ | User | +------------------+ | Mac | | Manish | | mysql.infoschema | | mysql.session | | mysql.sys | | root ... Read More
This example demonstrates how to get battery level and state in Android.Step 1 - Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 - Add the following code to res/layout/activity_main.xml. In the above code, we have taken a text view. it contains battery percentage.Step 3 - Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.BatteryManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; public class MainActivity extends AppCompatActivity { int view = R.layout.activity_main; TextView text; @RequiresApi(api = ... Read More
To front pad zip code with 0, use LPAD() function in MySQL. The syntax is as follows −SELECT LPAD(yourColumnName, columnWidth+1, '0') as anyVariableName from yourTableName;To understand the above concept of LPAD() to add front pad zip code with 0, let us create a table. One of the columns of the table is Zip Code. The following is the query to create a table.mysql> create table ZipCodePadWithZeroDemo −> ( −> Name varchar(200), −> YourZipCode int(6) −> ); Query OK, 0 rows affected (0.44 sec)Insert some records in the table. The query to insert records is as follows ... Read More