Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par RAGHU P R , windows administrator , spectrum softtech solutions pvt ltd
Date de publication: 2016/04/27
Jehangir Wahid
par 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
par 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
par 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
par Mourhaf Alhalabi , Systems administrator / Agile / Scrum

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
par 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
par Nader Idkeidek , IT CONSULTANT , NADERCO-JO

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

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

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

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
par Ali Omer , IT MANAGER , Al-Saad General Contracting Company

Yes (SQL mean structural query language)

عبدالرزاق رحمون
par عبدالرزاق رحمون , 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