what is SQL and MYSQL?

-

 

what is SQL and MYSQL?

Ans- SQL stands for structured query language, SQL is a language which is used to communicate with database and MYSQL is a server which contains one more table, MySQL is an Open Source, Fast and Reliable Relational Database Management System (RDBMS) software like Oracle, Sybase, MS SQL Server etc. It was developed by Michael Widenius and AKA Monty and is alternative to many of the commercial RDBMS.

Comments

Post a Comment

Popular posts from this blog

What is DBMS and RDBMS?

-
Image
  What is DBMS and RDBMS? Ans- DBMS  stands for Database Management System, and RDBMS  is the acronym for the Relational Database Management system. In DBMS, the data is stored as a file, whereas in RDBMS, data is stored in the form of tables
Read more

what is data, information and knowledge?

-
Image
what is data, information and knowledge? Ans-    Data:-  Data is collection of row facts without proper Meaning, Each row facts having meaning but when we read combinedly then no meaning.  Information:- Information is the result of re-ordered/ Re-processed of data.  Knowledge:- knowledge is the   recall the information. When we evaluate information is called information.
Read more

Q-1-What is difference between drop and delete command? Q-2-what is difference between drop and truncate commands? Q-3-Why truncate is DDL command? Q-4- What is select commands?

-
Image
 Q-1- What is difference between drop and delete command?   Drop command Delete command 1-Drop command belong to DDL. 2- Drop commands delete both header and table permanently. 3-Drop commands does not support where conditions.   Syntax: Drop table<Table_Name>;   1-Delete command belongs to DML 2-Delete commands delete the data / body part of the table. 3-Delete support where conditions. Syntax: Delete from<table_name> where <conditions>;       Q-2- what is difference between drop and truncate commands? Drop commands Truncate commands 1-Drop command belong to DDL. 2- Drop commands delete both header and table permanently. 3-Drop commands does not support where conditions.   Syntax: Drop table<Table_Name>;   1-Truncate commands belong to DDL. 2-Truncate command will delete both header and body of the table and re-create the header. 3-Truncate does not support where conditions.   Syntax: Truncate table<Table_name...
Read more