What is SQL?

0


SQL stands for Structured Query Language (pronounced "ess-que-el").  SQL is a language for interacting with databases. It is the standard language for relational database management systems, according to ANSI (American National Standards Institute). SQL statements are used to conduct operations like updating data in a database and retrieving data from one.

Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and other relational database management systems that use SQL are just a few examples. Although most database systems employ SQL, they often include their own proprietary extensions that are exclusively used on their own platform. Standard SQL commands such as "Select," "Insert," "Update," "Delete," "Create," and "Drop" can be used to do nearly anything with a database.



 
CREATE DATABASE databasename; 

USE databasename;

CREATE TABLE tablename (ID INT, NAME VARCHAR(20), ADDRESS VARCHAR(50));

INSERT INTO tablename (ID, NAME, ADDRESS) VALUES (1, 'AHSAN', 'JAX');

SELECT * FROM tablename;

Post a Comment

0Comments
Post a Comment (0)