[dx] Posted April 3, 2009 Share Posted April 3, 2009 Hi brainiacs,I've heard that there's some difference between mysql and sql base. So can someone explain it a lil bit more?And, please, for what is better use mysql and for what sql, or is it same? Regards Link to comment Share on other sites More sharing options...
jlhaslip Posted April 3, 2009 Share Posted April 3, 2009 They are mostly the same. SQL is a 'specification' for Relational Databases. Not all Databases meet all the SQL standards, but many are close.MYSQL is a Database software package that is 'mostly' standard to the SQL specifications. Many of the things you do in MYSQL can be duplicated using other Database softwares, but there are usually subtle differences in syntax and software capabilities. Link to comment Share on other sites More sharing options...
Synook Posted April 4, 2009 Share Posted April 4, 2009 Err, I would have said that SQL and MySQL were completely different. SQL is a standardised language used for processing data, while MySQL is a relational database management system that can be operated using SQL. It's like comparing PHP and Apache. Link to comment Share on other sites More sharing options...
[dx] Posted April 4, 2009 Author Share Posted April 4, 2009 I don't get it, but nevermind. Link to comment Share on other sites More sharing options...
Synook Posted April 5, 2009 Share Posted April 5, 2009 Well, think about it like this. You use the keyboard to manipulate your computer, in a similar way that you use SQL to manipulate MySQL databases. SQL is the tool, MySQL is the object. Link to comment Share on other sites More sharing options...
[dx] Posted April 6, 2009 Author Share Posted April 6, 2009 In some way, both are required and can't work without other. Basicaly said, they're same? Link to comment Share on other sites More sharing options...
Synook Posted April 6, 2009 Share Posted April 6, 2009 Well, to get extremely metaphorical, they are like a lock and key - the MySQL "lock" holds the information within, and you use the SQL "key" to access that information Link to comment Share on other sites More sharing options...
justsomeguy Posted April 6, 2009 Share Posted April 6, 2009 Basicaly said, they're same?No, they're not. SQL is a language. MySQL is a piece of software. You use the SQL language to interact with the MySQL software. Link to comment Share on other sites More sharing options...
[dx] Posted April 7, 2009 Author Share Posted April 7, 2009 Got it now, I think Little closer Link to comment Share on other sites More sharing options...
justsomeguy Posted April 7, 2009 Share Posted April 7, 2009 It's analagous to a language like HTML or Javascript vs. a web browser. HTML is not a web browser, and a web browser is not HTML. But a web browser does use HTML. Link to comment Share on other sites More sharing options...
[dx] Posted April 7, 2009 Author Share Posted April 7, 2009 Yes, yes. Understand now. As PHP and Apache too Link to comment Share on other sites More sharing options...
justsomeguy Posted April 7, 2009 Share Posted April 7, 2009 Sort of.. PHP is a little different, PHP is both a language and a piece of software, and it doesn't require Apache. Link to comment Share on other sites More sharing options...
s-p-n Posted April 7, 2009 Share Posted April 7, 2009 I think you meant to ask the difference between MySQL and MsSQL, but I'm not sure. There are many different kinds of SQL database structures, those two are only scratching the surface. If that's the case, there are slight differences in syntax between them all. For the most part, they all do the same things, and logic differs as well. From my experience, it's easier to find tutorials and help for MySQL than any other you might want to use. (MsSQL, SQLite, Postgre SQL, etc) Many popular hosts are starting to accept all of these, so compatibility isn't that much of an issue.Sorry if this was off topic Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.