iyeru42 Posted March 20, 2007 Share Posted March 20, 2007 I was wondering what the differences were between the two. Link to comment Share on other sites More sharing options...
jesh Posted March 20, 2007 Share Posted March 20, 2007 Well, for starters, SQL is a type of language (Structured Query Language) that is used to query databases whereas MySQL is a database management system that allows you to create databases. You would use SQL to run queries against MySQL databases. Link to comment Share on other sites More sharing options...
iyeru42 Posted March 20, 2007 Author Share Posted March 20, 2007 Well, for starters, SQL is a type of language (Structured Query Language) that is used to query databases whereas MySQL is a database management system that allows you to create databases. You would use SQL to run queries against MySQL databases.Well, I always thought MySQL was different than SQL because some of the stuff in MySQL can't be used in SQL (for queries.) Link to comment Share on other sites More sharing options...
midnite Posted March 21, 2007 Share Posted March 21, 2007 yes, it's true. Every software have some special alterations, that they will add some self-developed functions that they think those will make the queries run faster and smoother. So, in another words, their SQL are not that standard. But you need not worry. The basic stuff are all the same Link to comment Share on other sites More sharing options...
astralaaron Posted April 1, 2007 Share Posted April 1, 2007 I think he means the difference between mSQL and MySQLI would like to know the diff also :-) Link to comment Share on other sites More sharing options...
Kevin M Posted April 2, 2007 Share Posted April 2, 2007 Ok, I don't have very much general SQL knowledge, but here's my understanding:MySQL is a database system. SQL is a language to query a database (Like MS SQL, MS Access, Oracle etc.). MySQL is a type of database similar to the other ones stated (MS SQL etc.). SQL is just many different commands to connect, query and then display the information in a database depending on what you do with it. So there isn't a way to compare which is better because they are two differnt things (Just a similar name). MySQL commands are very similar to SQL commands because MySQL databses/commands are based from SQL commands (I believe, but I may be wrong.). SQL can be used to query many different types of databases depending on what you have installed on your server/host, whereas, if you use the MySQL commands, they can only be used for a MySQL database.Hopefully that makes some sense. I can clarify if anyone wants. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now