Thursday, October 22, 2009

Should i learn microsoft sql server as database or mysql and are they similar to each other?

actually i am a computers engineering student and i want to learn a database. someone told me that the syntax of both microsoft sql and mysql is same- meaning that if i learn mysql, i will also be able to work on microsoft sql. is this true? and what should i learn?



Should i learn microsoft sql server as database or mysql and are they similar to each other?internet security



The SQL standard is governed by ANSI, so you notice a database supports say ANSI-92 SQL.



The difference between MS-SQLServer and MySql is one of open versus proprietary. MySql is free and is arguably used more than any other RDBMS to support the web. MS-SQLServer is a Microsoft product, which you normally have to pay for.



Should i learn microsoft sql server as database or mysql and are they similar to each other?network security



And once you get sucked into Microsoft products you find you need other things to make it all work, none of which are free or cheap.
MySQL is Free and opensource. MS SQL is costly database. If you are doing to develop application for web, you can go with MySQL. If you need transactional database for financial application, you need MS SQL.



Yujin



www.scriptinstallation.in

No comments:

Post a Comment