SQL Basic- Important thing Keep Mind it....

SQL Basic- Important thing Keep Mind it....

04:03

Important thing Keep Mind it.... 

Important Thing


  • Some database systems require a semicolon at the end of each SQL statement.
  • Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.



Important SQL Commands


Command
             Description

SELECT

             Show data from a database

INSERT

             Insert new data into a database

UPDATE

             Update data in a database

DELETE

             Delete data from a database

CREATE DATABASE

             Create a new database

ALTER DATABASE

             Modifies a database

CREATE TABLE

             Create a new table

ALTER TABLE

             Modifies a table

DROP TABLE

             Deletes a table

CREATE INDEX

             Creates an index (search key)

DROP INDEX

             Deletes an index

About

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Subscribe to: Post Comments ( Atom )