what is the difference between sql server and mysql
What is the difference between sql and mysql, why we use mysql for php. compare to sql mysql have some more function is not avaliable like trigger, store procedure like that , can any one explain me the purpose.
Re: what is the difference between sql server and mysql
SQL server is a software of Microsoft.
MySQL is a software of the Swedish company MySQL AB, now owned by Sun Microsystems, a subsidiary of Oracle Corporation.
MySQL is free (or not very expensive) since it is available under the terms of the GNU General Public License.
There were old versions of MySQL which had less features than SQL server, because MySQL was a younger software. But now the differences are not very important. At least, and contrary to what you seem to say, MySQL has triggers and stored procedures.
Edit: When searching in Google, you might arrive to pages comparing SQL Server with very old versions of MySQL, and you will have the wrong feeling that SQL Server is far better.
Last edited by olivthill2; June 2nd, 2010 at 08:47 AM.