two basic questions about MySQL

I am a developer previously working on SQL Server and Windows platform. I am learnin开发者_如何学编程g 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

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.

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

2) Yes, it is supported.