Are stored procedures and triggers the same in Sql Server and MySQL?

I have two stored procedures and one trigger for a class I am taking that are done in sql server 2005. I want to recreate them in mysql with phpmyadmin. Everytime i put them in I get a 1064 error. Is this becuase phpmyadmin d开发者_如何学运维oes not handle stored procedures or triggers well, or is it becuase the syntax from sql server 2005 to mysql is very different? If it is this, then where could i go online to learn the correct syntax to write my stored procedures and triggers in mysql/phpmyadmin... or should I just pick up a book at barnes and nobles? This is my senior project.

The syntax and feature sets in MySQL will be slightly different, but the concepts and usage patterns and design motivations will be very similar if not identical. I suggest reading up in the MySQL manuals before buying any books:

Triggers

Stored Procedures

So you can definitely port your T-SQL code to MySQL's SQL dialect.

It's because MySQL does not support Transact-SQL, which is the SQL variant Sybase and MSSQLServer use to program triggers and stored procedures.

So, the answer to your question is: NO.