Hello, 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 does 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.
A:
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.
Pablo Santa Cruz
2010-04-12 20:09:23
So if i want to make these procedures and triggers work... am i not able to at all?
2010-04-12 20:13:19
Not without some testing and modifications.
Pablo Santa Cruz
2010-04-12 20:23:03
+1
A:
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:
So you can definitely port your T-SQL code to MySQL's SQL dialect.
Cade Roux
2010-04-12 20:19:49
Thank you! I was jus unsure if it was becuase of the software or t-sql problems.
2010-04-12 20:27:34
@user314877: There might be idioms in T-SQL that are a challenge to transcribe, but flow control and the like should come over easily.
lexu
2010-04-12 20:31:01