We can login through this command:
# [mysql dir]/bin/mysql -h hostname -u <UserName> -p <password>
Every row of a table is identified uniquely by primary key. There is only one primary key for a table.
Primary Key is also a candidate key. By common convention, candidate key can be designated as primary and which can be used for any foreign key references.
- MySQL is open source software which is available at any time and has no cost involved.
- MySQL is portable
- GUI with command prompt.
- Administration is supported using MySQL Query Browser
Maximum of 16 indexed columns can be created for any standard table.
In Relational database tables are associated with each other and we used foreign key to maintain relationships between tables. We used join clause to retrieve data from associated tables. The join condition indicates how column in each table are matched against each other.
There are two types of joins clause in SQL
- Inner join
- Outer join
Outer join is again divided into parts −
Stored procedures are a pieces of the code in written in PL/SQL to do some specific task. Stored procedures can be invoked explicitly by the user. It's like a java program , it can take some input as a parameter then can do some processing and can return values.
On the other hand, trigger is a stored procedure that runs automatically when various events happen (eg update, insert, delete). Triggers are more like an event handler they run at the specific event. Trigger can not take input and they can’t return values.
As we know both SQL and NoSQL are the types of databases and on the basis of their implementation and nature, both are categorized as of two types.
The following are the important differences between SQL and NoSQL.
Sr. No.
Key
SQL
NoSQL
1
Type
SQL database is generally classified as a Relational database i.e. RDBMS.
While NOSQL database is known as non-relational or distributed database.
The process to alter the structure of a database is basically categorized into two ways one is Normalization and other is Denormalization.
The following are the important differences between Normalization and Denormalization.
Sr. No.
Key
Normalization
Denormalization
1
Implementation
Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it.
Denormalization is used to combine multiple table data into one so that it can be queried quickly.
NodeJs and AngularJs both are widely used nowadays for application development. There are significant differences between both of them.
The following are the important differences between NodeJS and AngularJS.
Sr. No.
Key
NodeJS
AngularJS
1
Type
NodeJs basically is a cross-platform run-time environment that is required for applications written in JavaScript language.
While AngularJs is a framework that is open source and used for web application development. This framework is developed by Google.
Following are the important differences between Stateless and Stateful.
Sr. No.
Key
Stateless
Stateful
1
Definition
Stateless Protocol is a network protocol in which Client send request to the server and server response back as per the given state.
Stateful Protocol is a network protocol in which if client send a request to the server then it expects some kind of response, in case of no response then it resend the request.