![]() ![]() It is very tightly knit with the OS, moreso than SQL Server in my opinion. ![]() The hardest part of MySQL is if it's on Linux. Remember how you learned SQL Server and apply the similar learning structure to picking up MySQL. From a syntax perspective, both try to be ANSI compliant but are not 100%. Take what you know about SQL Server and try to apply larger patterns. I've ran enterprise clusters of MySQL and SQL Server, there are major differences. (some of the expressed views might be outdated, so take it with a grain of salt, and verify). Its read performance is among the best, and is very well optimized for a large number of clients connecting to it.īut really once you worked with one RDBMS, switching to another is really no big deal. MySQL is good though in the fact that it scales horizontally well, for something that comes free. Like you still don't have FULL OUTER JOIN, it doesn't require GROUP BY when aggregating (weird rules), its type system is a hot mess, and its procedural language is something that almost nobody touches, for good reasons probably (I did that once, and it was an ugly experience). MySQL is kinda like the hipster that said that it can do the same, but for free, and it did what was necessary for 90% of the developers, and over time it kinda caught up and exceeded many features but it still feels raw. Errors are better reported, T-SQL is a sane procedural language, data types are clearly defined. ![]() MSSQL is better when it comes to overall syntax and things you can do with it. Thanks to -sniff- for the awesome header image!īoth are kinda SQL. You should post these to /r/learnsql instead. Note /r/SQL does not allow links to basic tutorials to be posted here. Please view the Wiki for online resources. Learning SQLĪ common question is how to learn SQL. SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3įor those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this: This will greatly increase your chances of receiving the help you desire. If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own. If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform. When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so: The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |