ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل RAGHU P R , windows administrator , spectrum softtech solutions pvt ltd
تاريخ النشر: 2016/04/27
Jehangir Wahid
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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 ..

Nader Idkeidek
من قبل Nader Idkeidek , IT CONSULTANT , NADERCO-JO

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

Danenjay Singh
من قبل 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
من قبل Ali Omer , IT MANAGER , Al-Saad General Contracting Company

Yes (SQL mean structural query language)

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

 

المزيد من الأسئلة المماثلة