This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Im switching from MSSQL to MySQL. This is my first time using MySQL. I have to create tables.. stored procedures. However everything I try to copy from MSSQl come up with errors. Can someone point out what is wrong with this stored procedure? What are some of the differences between the two databases that I should keep in mind
CREATE PROCEDURE dbo.ObtainPhotoInfo @photoID varchar(255) AS SELECT [ID] , itemDescription, unitprice FROM itemlist WHERE [ID] LIKE @photoID GO