Home java Is all SQL databases support SQL language syntax?

Is all SQL databases support SQL language syntax?

Author

Date

Category

Different commands of access to different SQL (MS SQL , MySQL , Oracle )? I just need to study the database based on MS SQL with Java, and the material on this topic is very little …


Answer 1, Authority 100%

Mostly all SQL databases support the same syntax from SQL . At the same time, the most basic commands work on one syntax that in MySQL , in MS SQL . Some syntax sugar is possible or vice versa, somewhere you have to specify the name of the table with the schema indicating. Therefore, my advice to you, write on all SQL-typical database with the same syntax and do not worry. If anything, you will understand right away, since there is even a difference, then they are petty.

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions