Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to repair MySQL tables from the command line?
The repair of MySQL tables is only applicable to MyISAM engine type, not for InnoDB. Therefore, we need to change the Engine type to MyISAM. The following is an example. Creating a table mysql> create table RepairTableDemo -> ( -> id int, -> name varchar(100) -> ); Query OK, 0 rows affected (0.51 sec) To convert this table to engine type MyISAM, use ALTER. mysql> ALTER TABLE RepairTableDemo ENGINE = MyISAM; Query OK, 0 rows affected (1.14 sec) Records: 0 Duplicates: 0 Warnings: ...
Read MoreHow can I restore the MySQL root user full privileges?
We can restore the MySQL root user full privileges with the help of UPDATE command. Firstly, you need to stop mysqld and restart it with the --skip-grant-tables option. After that, connect to the mysqld server with only mysql (i.e. no -p option, and username may not be required). Issue the below given command in the mysql client to restore the MySQL root user with full privileges. mysql> UPDATE mysql.user SET Grant_priv = 'Y', Super_priv = 'Y' WHERE User = 'root'; Query OK, 0 rows affected (0.04 sec) Rows matched: 1 Changed: 0 Warnings: 0 Above, ...
Read MoreHow to check internet connection in android?
This example demonstrate about how to check the state of internet connection through broadcast Receiver.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 − To find the internet status we have to add network state permission to AndroidManifest.xml file as shown below. Step ...
Read MoreHow to create CircularImageView in android?
This example demonstrate about how to Create CircularImageView 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 −To make circler view, we should add CircularImageView library in gradle file as shown below.apply plugin: 'com.android.application' android { compileSdkVersion 28 defaultConfig { applicationId "com.example.andy.myapplication" minSdkVersion 15 targetSdkVersion 28 versionCode 1 versionName "1.0" testInstrumentationRunner "android.support.test.runner.AndroidJUnitRunner" } buildTypes { release ...
Read MoreCreating orders in SAP system using .Net
You can handle it by creating an array and insert an object into Array. Bapisdhd1 order_header_in = new Bapisdhd1(); order_header_in.DocType = "OR"; order_header_in.CollectNo = "111022"; order_header_in.SalesOrg = "11011"; order_header_in.DistrChan = "100"; order_header_in.Division = "000"; order_header_in.DlvBlock = "010"; order_header_in.PurchNoC = "TEST ORDER"; newOrder.OrderHeaderIn = order_header_in;
Read MoreSum of all proper divisors of a natural number in java
Following is the Java program which prints all the sum of all the divisors of a given number.
Read MoreDisadvantages of using row based tables in SAP HANA
Row based tables are used when only one record has to be processed at a time. Row based table doesn’t support aggregations and fast searching.When your application needs to access a complete record or a complete row it is recommended to use row based tables.
Read MoreUsing aggregated in SAP HANA
SAP HANA is an in-memory database so all data resides in memory all the time and hence all calculations and functions can happen directly and hence materialized aggregations are not required in SAP HANA database.With the use of column store, data is available vertically and hence operations on different columns can be easily performed.
Read MorecompareTo() definition mistake?
The example works correctly. The compareTo() method is called by a string object and takes another string object as argument. The return value is integer and is difference in Unicode values of characters of respective strings when they are not equal. The value can be -ve, 0 or +ve.
Read MoreWhy are numbers represented as objects in python?
Everything in Python is an object, and that includes the numbers. There are no "primitive" types, only built-in types.Numbers, however, are immutable. When you perform an operation with a number, you are creating a new number object.
Read More