Syntax Differece b/w MySQL and MS-SQL

Anon

Does anybody know if there is even a difference in syntax between MySQL and MS-SQL. I am currently working on SQL 7 Server and school and I found a possible job prospect asking for MySQL.....I just need to know if that what I'm learning can be used exactly the same with MySQL ie. tables, stored procedures, triggers, etc.

Thanks

Anon

You'll find that all of your queries run the same on both, 'cept for the create/append tables as the two vary in the names of the data types.
Mysql has no support for triggers (you need to write this support into your app) nor SPROCs (Again, write them into your app).
Mysql does support transactions if you're using the Berkley tables (MySQL-MAX will give you that, but you have to explicitly declare that you wish to use the Berkley table rather than ISAM or MyISAM).

Anon

Well

Mysql does not support

views
derived tables
stored procedures and functions
subselect
scalar subqueries
triggers
userdefined types
dri (to some extent though)
check constraints
full outer join

(This is not intended to be a full list.)

In addition to this there are differences with e.g. built in funtcions, datetime handling, datatypes.

Syntax for data manipulation statements does not differ match, keeping in mind the limitations of Mysql and that most non sql-standard featurs in T-sql is not implemented in Mysql. (E.g. update with a from clause, select @@identity etc.)

[deleted]

The syntax differences are very small, and documented in the documentation.

The biggest problem you'll find is that mysql is very limit, it basically can't do any of the things that make a database usefull;
no subqueries, no stored procedures, no functions, nofunctionalindexes, no PK/FK relations, the list is long.

Instead of MySQL, look at PostgreSQL. That's also free, and allmost as feature-rich as oracle or ms-sql.

A forum, a FAQ, email notification, what else do you need?