Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Are the queries used in mssql, mysql, oracle databases are the same? Which one is widely used?

user-image
Question added by RAGHU P R , windows administrator , spectrum softtech solutions pvt ltd
Date Posted: 2016/04/27
Jehangir Wahid
by Jehangir Wahid , Lead Software Developer , Inaequo Solutions

They are not same at all,

MS SQL is used with .NET Framework,

MYSQL is usually used with Php.

 

Sadik Shaik
by Sadik Shaik , IT Analyst , TATA CONSULTANCY SERVICES

Most of the open source projects uses MySQL. But MsSQL has more security than MySQL.Both are DBMS's Products.MySql requires less spaces on disk, and uses less cpu.

Ahmed Ramadan
by Ahmed Ramadan , MIS Consultant and Business Analyst , Abu Dhabi Isalmic Bank

 

Not all queries are same it is difference from DBMS and other .MySQL is widely used.

Mourhaf Alhalabi
by Mourhaf Alhalabi , Data analyst

each one of those RDBMSs has its own keywords, but ingeneral DML statements are same, DDL and DCL have more platform-oriented manners.Most differences apear when dealing with stored procedures and programmability objects.

R N
by R N , web designer web developer , Abc

Queries (SELECT, DELETE, INSERT, UPDATE ..) are the same.

They differ in some details regarding AutoIncrement, data types and some other details ..

Not all queries are same.MySQL is widely used.

Nader Idkeidek
by Nader Idkeidek , IT CONSULTANT , NADERCO-JO

Yes the queries used in mssql, mysql, oracle databases are the same

Danenjay Singh
by Danenjay Singh , Associate Software Engineer , Magictel Solutions Pvt Ltd

No, they are not same. Widely used database is Mysql

Mohammad Riyazuddin
by Mohammad Riyazuddin , Web Developer , PYD, King Saud University

Conceptualize if you see all the database engines follow the RDBMS system (i.e Codd rules).

Syntax may vary from one db to another db.

MSSQL is from Microsoft.

MYSQL is an open source DB.

Oracle is a popular DB from Oracle corporation widely used for its security in large enterprise applications.

Mostly people prefer to use MySql db because its a freeware.

 

 

Ali Omer
by Ali Omer , IT MANAGER , Al-Saad General Contracting Company

Yes (SQL mean structural query language)

عبدالرزاق رحمون
by عبدالرزاق رحمون , IT engineer , Ministry of Education

MS SQL Server uses Transact SQL which is an extension of SQL originally developed by Sybase and used by Microsoft. Oracle, meanwhile, uses PL/SQL, or Procedural Language/SQL, the widely used is mysql ;

 

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.