From MSSQL/TSQL to MYSQL

Have been working on MSSQL for quite a while. Now I started to work on MySQL. After you got the basic knowledge of SQL. I guess switch from MSSQL to MYSQL should not be too difficult.
When I try to wrote some Stored procedure in MYSQL. I find it little bit hard, as the syntax and keywords is a bit different. Therefore I start to drop down some notes about the difficulty i encountered when I using MYSQL.
E.g.
You need to ensure you have place semi-colon “;” at the end of each of the MySQL statement.
When you declare a variable in Stored procedure you do not need to put “@” in front of the variable in MySQL
Hope you find it useful too.

Leave a Reply