Tutorial :Learning resources to transerfer my MS SQL Server knowledge into MySQL



Question:

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)


Solution: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.


Solution:2

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


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »