two basic questions about MySQL

Question

Hello everyone,

I am a developer previously working on SQL Server and Windows platform. I am learning MySQL on Windows platform. I have two basic questions which does not find definite answer yet,

1. Does MySQL support T-SQL to write store procedure? If not, are there similar technologies to T-SQL in MySQL world (I am referring to stable/mature technologies);
2. If I download lastest MySQL version (version 5.1), does it support transaction or not (I heard MySQL does not support transaction before)?

thanks in advance, George

Answer 1

1) Yes, in the latest version there is full support for Stored Procedure.

2) Yes, it is supported.

Answer 2

1. T-SQL: It doesn't have a specific name, but yes, it supports stored procedures and functions (Manual Chapter 19)
2. Transactions: Yes, MySQL supports them in some of its storage engines (InnoDB, for instance). Some storage engines don't support them (MyISAM, for instance), but you can just not use those.

When working with MySQL, I always have a bookmark available for directly accessing the (in my opinion) very good Reference Manual.