1

I'm an experienced MS SQL Server developer
But with my first MySQL project I got problems with very simple issues
So can anyone suggest good resources helping me transfer my MS SQL Server knowledge into MySQL
I'm not looking for a complete reference guide for MySQL
I'm looking for something targeted for experienced SQL developers

EDIT: here are sample of issues I faced (thanks Neil Butterworth)
1- Where to write my first "select * from", NOW I know that
- I've to download MySQL which is NOT coming with IDE
- I can pick up SQLyog as MySQL IDE

2- How to execute multiple sql statements in the same query(done)
3- How to declare variables (done)
4- How to write simple cursor (still trying)
5- How to add primary key to existing table by MySQL query not by IDE (still trying)
6- What is the different between Wamp Server and [MySQL + SQLyog] (still trying)

Community
  • 1
  • 1
Ahmed Mozaly
  • 1,454
  • 2
  • 15
  • 22
  • It would be a good idea to summarise the issues you have problems with in your question –  Apr 18 '09 at 18:29
  • There was a similar question with very usefull answers: [http://stackoverflow.com/questions/368858/hidden-features-of-mysql](http://) – Irina C Apr 18 '09 at 18:45

2 Answers2

2

Here's a good place to start: Migrating From MS SQL to MySQL

Jose Basilio
  • 50,714
  • 13
  • 121
  • 117
1

There probably aren't going to be any guides that address your specific issues, so I'd just recommend reading through the excellent documentation on the MySQL website. If you have a particular problem that's causing grief, and that isn't addressed in the docs, then ask about it here.

Don Werve
  • 5,100
  • 2
  • 26
  • 32