Triggers cannot be defined on views as well. It means only one trigger can be executed on the table if any event happens on the table. In MySQL, Triggers are limited to only one action per timing. There are certain limitations in My SQL. MySQL was created by a Swedish company MySQL AB. The features are like support to cross-platform, stored procedures, triggers, cursors, data definition language, ACID compliance, SSL support, views updatable, partitioning, Indexing, select, commit grouping, Unicode support and many more.Its type is RDBMS and available in the English language only. SQL Server is defined as a relational database management system (RDBMS). It supports the platforms that are Linux, Microsoft Windows, and Windows server. SQL Server provides the language drivers to connect easily with any code. It supports all platforms like Windows, Mac OS, Solaris, Free BSD, Linux, etc. It is also referred to as an Open-source relational database management system (RDBMS).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |