SQL Short Notes
SQL Short Notes What is SQL? • sql is stand for structured query language. • This database language is mainly designed for maintaining the data in relational database management systems. • sql is standard language for accessing and manipulating database. Types of SQL Commands : DDL COMMANDS: • DTM (Data Defined Languages ) used to change the structure of the table Like creating the table, altering the table & Deleting the table. • All the commands in the DDL are auto Committed that means it permanently save all the changes in the database. 1. CREATE : This command is used to create a new database or table. Syntax: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, Example: CREATE TABLE Employee EmployeelD int; FirstName varchar(255), LastName varchar(255), AddressLine varchar(255), City varchar(255) ); 2. UPDATE : The UPDATE statement is used to modify the existing records in a
Comments
Post a Comment