WHAT ARE TRIGGERS?
A trigger is a set of SQL statements stored in the database structure. A Trigger is a database object that is attached with the table in SQL.A SQL trigger is fired whenever an event or function associated with a table occurs ....
What is Normalization In Database?
The structuring of Database is normalization, Normalization is the process of restructuring tables to eliminate design problems. This process removes redundant data, makes it possible to access data more easily.
Databases To Learn In 2017
PostgreSQL releases its two versions 9.5 and 9.6, this year. They launched the UPSERT functionality after a long time that we know from MySQL (aka ON DUPLICATE KEY UPDATE), better full text search and speed improvements.
Difference between Delete, Truncate, Drop
Delete command is used to delete all the rows from the table. If we use where clause then according to condition specific rows will be deleted. In del
Uses of Stored Procedure in Database
It is a set of structured query language statement with given name. It is stored in the database in the compiled form.It is store in the compile form that’s why it can be shared by many program.
Where Clause in SQL Statement
Where clause is very important clause for filtering data .It search the records from the table according to the condition given in the where clause.
View in SQL
A view is a SQL statement which is stored in the database with a name. A view is actually a formation of a table in the form of a predefined Structured Query Language (SQL) query.
Trigger In SQL
Triggers are store procedure, which are automatically executed or fired when some events occur like deletion, insertion of data. Triggers are database object which is attached to a table and is executed automatically.
SQL Constraints
Constraints are used to apply some rules for the record in a table. If any rule is violated between constraint and data, then the action is aborted by the constraint.
SQL Queries
In previous article we have discussed about SQL and some queries. In this part we will continue on SQL Queries: Customer IdNameAddressContact Marks
Introduction to SQL
SQL stands for Structured Query Language. The structured query language is used to manipulate and access the databases. SQL is an ANSI (American National Standard Institute) standard.
How to create database in MySQL using PHP?
The CREATE DATABASE statement is used to create database. (Note: Before creating database you must first connect with database server).Here is an example to create database using PHP: