Ankith Reddy has Published 996 Articles

IF ELSE statement in a MySQL Statement?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

745 Views

In an If-Else statement, the condition is evaluated to be true or false depending on the value. Let us see an example. Firstly, we will create a table. The CREATE command is used to create a table. mysql> create table IfelseDemo - > ( ... Read More

Is the primary key automatically indexed in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

2K+ Views

Yes, primary key is automatically indexed in MySQL because primary key, index, etc gets stored into B-trees. All engines including InnoDB as well as MyISAM automatically supports the primary key to be indexed. The primary key is implicitly indexed in InnoDB, MyISAM, and other engines. Let us create a table ... Read More

Advantages of using MySQLi over MySQL?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

3K+ Views

MySQLi is also known as MySQL improved Extension. It is a relational SQL database management system. It is often used inside PHP to provide an interface with the MySQL databases. Some of the reasons why MySQLi is famous are given below − MySQLi uses the standard form of the ... Read More

Fiber To The Home

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

501 Views

Definition Fiber to the home (FTTH) is a technology to deploy optical fibers in the local loop of the telephone networks to the users’ home for providing high-speed data connectivity. It replaces the existing copper wires as telephone lines to the customer premises by optical fibers that allow much greater ... Read More

Universal Mobile Telecommunications System

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

6K+ Views

The Universal Mobile Telecommunications System (UMTS) is a broadband, packet-based, 3G mobile cellular system based upon GSM standards. The specifications of UMTS covers the entire network system, including the radio access network, the core network and user authentication. Features UMTS is a component of IMT-2000 standard of the International Telecommunications Union ... Read More

Long-term Evolution (LTE)

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

2K+ Views

Long – term evolution or LTE is a standard for wireless technology based upon GSM/EDGE and UMTS/HSPA technologies. It offers increased network capacity and speed to mobile device users. It is an extension of the 3G technology for high-speed mobile communications. LTE-Advanced is an improvement over LTE that meets the ... Read More

Error 1046 No database Selected, how to resolve?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

3K+ Views

The 1046 error occurs if you forget to select any database before creating a table. Let us see how and why this error occurs. We will try to create a table without selecting a database − mysql> CREATE table MyTable1 -> ( -> ... Read More

How to set NOW() as default value for datetime datatype in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

8K+ Views

We can set the now() function as a default value with the help of dynamic default. First, we will create a table with data type” datetime”. After that, we will set now() as the default value for column “MyTime” as shown below. Creating a table. mysql> create table DefaultDateTimeDemo ... Read More

What is the C# equivalent for the Java System.exit(0)?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

2K+ Views

The C# equivalent for Java System.exit(0) is − Environment.Exit(exitCode); The Environment.Exit() method terminates this process and returns an exit code to the operating system. Above, use exitCode as 0 (zero) to show that the process completed successfully. Use exitCode as a non-zero number to show an error, for ... Read More

How to add not null constraint to existing column in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

2K+ Views

To add not null constraint to an existing column in MySQL, we will use the ALTER command. This is a type of validation to restrict the user from entering null values. Let us see an example. Firstly, we will create a table. The CREATE command is used to create a ... Read More

Advertisements