adspace


What is the difference between sql, mysql and sql server?

Answer Posted / Nitish Raj

SQL (Structured Query Language) is a standard language for querying and managing databases. MySQL and SQL Server are two popular relational database management systems that use SQL to interact with their databases. Differences include: MySQL is open-source, while SQL Server is proprietary software; MySQL uses the InnoDB engine by default, while SQL Server uses its own storage engines like Heap and Table; MySQL supports a maximum of 64KB for a single column, while SQL Server has no such limit.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1028


Is primary key always clustered index?

1101


What is your daily office routine?

2353


How do I remove duplicates in two columns?

1202


define sql insert statement ? : Sql dba

1110


Does group by remove duplicates?

1120


Do we need to rebuild index after truncate?

1154


Can we use distinct and group by together?

1147


what is sql server agent? : Sql dba

1189


how to start mysql server? : Sql dba

1279


Can delete statement be rollbacked?

1065


what is collation? : Sql dba

1242


What is the best sql course?

1064


what are the advantages of sql ? : Sql dba

1154


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102