hey mate, basically I am a web developer but I can develop a database because I have knowledge on MS. Access, Visual Basic and SQL Server 2000. I know MySQL is very popular at this moment. So I need to know what is the differences in between SQL Server and MySQL. I already tried to find some useful information from google but still have lots of confusion. Can you tell me something about MySQL? Thanks,
MySQL is simply another RDMS and like all of them it has a little bit of unique elements in terms of its advanced SQL and syntax for stored procedures etc. 3w School has examples in MSSQL, MySQL and Oracle as a starter for 10 of the differences in terms of language http://www.w3schools.com/sql/default.asp
MySql is a crap with the spatial Types and function, mostly of documentation tell me that will be implemented soon. MySql have the deafult table MyIsam that not support the referential integrity, you nedd to use the table InnoDB.
Sorry but I am also new for mysql. I have some questions about mysql that in php language only mysql is used or other database is supported by php.
There is some technical differences in MySQL and SQL Server when it comes down to the ANSI SQL standard: * MySQL does not support Triggers, SQL Server does. * MySQL does not support User Defined Functions, SQL Server does. * MySQL does not have Cursor Support, SQL Server does. * MySQL does not support Stored Procedures, SQL Server does. * MySQL does not have FULL JOIN capabilities, SQL Server does. * MySQL has limited Import/Export capabilities, SQL Server has full support for Import/Export. * MySQL has limited Transaction Support while SQL Server offers full Transaction Support.
I thought MySQL was more popular. I would like to see some advantages of MySQL over SQL , the opposite of what you have just did now. If possible .
Mysql 5.0 has stored procs, triggers, functions, cursors and transactions. In short, a fully featured database. You're using PHP, so pick PDO to connect, because it's more flexible.
PHP can work with many different database servers. MySQL is probably the most popular but it also works with MSSQL, PostgreSQL, SQLite and many others. It depends mostly on which server is installed on your web server.
Just because it's more popular doesn't mean it is the best. Probably has more to do with mySQL = $0, MS SQL = $Lots. There are free "express" versions of MS SQL available but these have some limitations. The cheapest version of MS SQL that is available to the general public is SQL Server Standard at around $1200 per CPU to purchase. When it comes to hosting, MS SQL Standard costs the host around $100 per month per CPU. That can be a lot of money for a small host to recover.
The free version of MS SQL is also a relatively new compared to MySQL. Similarly, PHP has built in support for MySQL and whilst it can use MS SQL its not as intuitive and so you very frequently get a LAMP setup and people just use the MySQL blindly. MySQL 5 was a significant step forward but the majority of average website designers do not use the extended features like triggers or stored procedures so never saw the limitations of the earlier versions of MySQL
Nowadays, people tend to use mySQL because: 1. Free 2. Great support for PHP by Oracle 3. Can be customized more.