MySQL vs SQL

Pros, cons?

Let me know.

 

SQL is not a program...it's the language itself (INSERT, SELECT, etc.).

Maybe you're referring to Microsoft SQL Server?
Pros: fast, reliable, scalable
Cons: needs heavier hardware than MySQL to run smooth, Windows only, have to wait for MS if there's a vulnerability found, expensive

MySQL...Pros: fast, reliable, scalable, patches for vulnerabilities are same day or next, ginormous support community, free(!), can run better on lighter hardware than MSSQL, runs on most OSes
Cons: some ppl don't care for phpMyAdmin

 

I like phpMyAdmin.

Hmm... seems like mysql is the right choice?

 

I switched to it from MS SQL and never looked back. So, yes, go with that one.

 

Ok. Thank you very much for the help.

That saved me a lot of time

 

depends what you are doing

there is a hell of a lot that MySQL can't do that SQL Server can

Try using MySQL as your backend for a major financial system with billions of records.
In the corporate sector, most businesses either choose Oracle or SQL Server

 

wozza is right about that...for enterprise level apps, Oracle or MS SQL is the way to go. Alot of new features were just introduced with MySQL 5.0 and haven't fully matured yet.

 

Just a quick question...what exactly is the relationship between MySQL and phpMyAdmin. I have seen references to both but was wondering how they are related. Is phpMyAdmin for developing php using MySQL as the database?

Thanks!

 

phpMyAdmin allows you to have a user interface to manage your database. It gives you a visual representation of your database and allows you to use html forms to update it, rather than doing it all throw coded mysql queries. It's very useful.

 

phpMyAdmin is the web based front end tool to manipulate your MySQL database ie you can do your SELECT, UPDATE, DELETE statements in a query analyser and do backups or dumps.

MySQL is pretty nice but not a good choice for enterprise applications. Although as from v5.1 (or 5.0), stored procedures and triggers have been introduced, they are still in testing stages. And these facilities are really needed when it comes to databases.

 

Well played sir - MsSQL for sure! MySQL's price is nice but when a real database is needed SqlServer does the trick

MySQL is definitely improving though - now with the stored procs comin YeeHaw!

 

what are you talking about? it's FREE...

i agree with what has been discussed... for most people, mySQL should be good enough if you know how to tweak and tune it... but for enterprises, you should go for ms sql... for really big databases used by banks, etc., databases like oracle and db2 comes into the picture... for those really really really big ones, go for terradata...

 

There's also litesql or something like that

 

Is DB2 Relational?