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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How do I begin auto increment from a specific point in MySQL?
To begin auto increment from a specific point, use ALTER command. The syntax is as follows −ALTER TABLE yourTableName auto_increment = anySpecificPoint;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table AutoIncrementSpecificPoint −> ( −> BookId int auto_increment not null, −> Primary key(BookId) −> ); Query OK, 0 rows affected (0.56 sec)Now you can insert records using insert command.The query is as follows −mysql> insert into AutoIncrementSpecificPoint values(); Query OK, 1 row affected (0.17 sec) ...
Read MoreWhat are some of the applications of LASER?
LASER is an acronym for Light Amplification by Stimulated Emission of Radiation. The LASER action was first proposed by Einstein.Applications of a LASERA LASER can be used in many fields. Some of its usages are given here.Used In Welding and Melting: The laser beam welding is mainly used for joining components using high welding speeds and low thermal distortion.Used In Holography: The reason that a hologram cannot be made without a LASER source is that coherence length for laser source can be very high due to which sustained interference pattern will be recorded on a hologram. This suggests the indispensable ...
Read MoreHow to make Android character by character display text animation?
This example demonstrate about How to make Android character by character display text animation.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 src/MainActivity.javapackage com.example.andy.myapplication; import android.os.Bundle; import android.support.v7.app.AppCompatActivity; public class MainActivity extends AppCompatActivity { @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); Typewriter writer = new Typewriter(this); setContentView(writer); writer.setCharacterDelay(150); writer.animateText("Sample String...Sample String...Sample String..."); } }In the above code, ...
Read MoreWhy zero (0) is the first number?
Zero (0) is used as a number and also as the numerical digit. Zero gives the additive identity of the integers, real numbers, and many algebraic structures. It is used as a placeholder for writing numbers.Natural numbers start from 1, then 2 and so on. We cannot count backward with them. Integers, on the other hand, allows us to count backward. Zero winds up being a good choice for the number that should come after 1 as we count backward. Integers can go in both directions, to a positive infinity and also in the reverse direction to a negative infinity. ...
Read Moreftp_get_option() function in PHP
The ftp_get_option() function returns runtime options of the FTP connection.Syntaxftp_get_option(con,option);Parameterscon − The FTP connection.option − The runtime option to return.The following are the possible values −FTP_TIMEOUT_SEC - The timeout used for network operationsFTP_AUTOSEEK - Returns TRUE if this option is on, FALSE otherwiseReturnThe ftp_get_option() function returns the value on success, or FALSE if the given option is not supported.ExampleThe following is an example −
Read MoreGet timestamp date range with MySQL Select?
To select timestamp data range, use the below syntax −SELECT *FROM yourTableName where yourDataTimeField >= anyDateRange and yourDataTimeField < anyDateRangeTo understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table DateRange −> ( −> DueTime timestamp −> ); Query OK, 0 rows affected (1.34 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into DateRange values('2016-11-13'); Query OK, 1 row affected (0.51 sec) mysql> insert into DateRange values('2016-10-14'); Query OK, 1 row ...
Read MoreWhat is the salary of ethical hacker in India?
A Certified Ethical Hacker (CEH) earns an average salary of Rs 367, 249 per year and the relevant experience strongly influences pay for this job which goes more than 15 lakh per year.A hacker is an expert in computer and network expert, who helps companies to realize their vulnerabilities. they are named as Hackers and Red Team etc., and work for businesses or government organizations.The ethical hacker has the proficient knowledge of various operating systems and hacking processes and techniques etc and needs to be updated all the time to grab any kind of threats. An ethical hacker is the ...
Read MoreHow to order DESC by a field, but list the NULL values first?
To order by a field and list the NULL values first, you need to use the following syntax. This will order in descending order −select yourColumnName from yourTableName group by yourColumnName is null desc, yourColumnName desc;To understand the above syntax, let us first create a table −mysql> create table OrderByNullFirstDemo −> ( −> StudentId int −> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table with the help of insert command. The query is as follows −mysql> insert into OrderByNullFirstDemo values(100); Query OK, 1 row affected (0.13 sec) mysql> insert into OrderByNullFirstDemo ...
Read MoreWhat is the daily routine of an average person?
Are you tired of popular social networking sites like Facebook or Instagram? Here are a few upcoming websites just like Instagram or Facebook you would love to try:PathIt is one other app for social networking purposes that lets you connect with the closest people. The only difference between Facebook and Path is the scope of connectivity. The Path app does not connect you with strangers; it connects you with family and closest friends.TumblrOne platform that is mainly driven by images and numerous amusing GIFs, videos, audio, chats, text files, quotes, and so much more. Recently, Tumblr has provided its users ...
Read MoreHow to make Animate text from one TextView to another in Android?
This example demonstrate about How to make Animate text from one TextView to another.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 text view and button, when user click on button, textview going to updateStep 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.Bundle; ...
Read More