Data Definition Language: A database is a systematic collection of data. Database systems are used to store, access, delete data. furthermore, it also systematically organize data in a database.This article briefly discuss about the use and importance of SQL ALTER Table . Data Definition Language is divided into-‘CREATE’,’ALTER’,’DROP’,’TRUNCATE’,’RENAME’. Technology like Database and SQL has grown exponentially in …
MySQL has many built in functions . Now many of us might be thinking that what are MySQL functions?, What are Built in functions?, How they work , and so on . This Article will guide you through Different MySQL built in functions , and will discuss about the use of them. What is Built …
SQL FOREIGN KEY Constraint: SQL FOREIGN KEY is a key used to link two tables in a database. A foreign key one table refers to a primary key in other table Note 1: A table can only have one primary keys, which may contain one or multiple fields. Note 2: A table containing the foreign key …
In this segment, you will be familiarized with the C program to find reverse of a string in C programming language with the help of using strrev() function which is defined under “string.h” header file and by using pointer. As we have discussed about string in the previous articles (Go through given link string). Now let …
Reverse of a string – free C programming tutorial Read More »
Our today’s topic of discussion is Auto Increment in SQL. This property are mostly used by the ‘Primary Key’ in the table. As the name suggests,It allows a random/unique number to generate every-time a record is inserted in the table.Without any further delay let us jump to today’s topic , and enjoy the essence of …