Going from MS SQL to MySQL - How difficult?

[Freamon]

IIRC, MS SQL has things like being able to read uncommitted transactions and also to create a temporary table dynamically in code, which is something that MySQL doesn't do for good reason.

MySQL has in-line views now:

mysql> select * from (select 1 from dual) x;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

[TheFaQQer]

I am pretty sure Oracle got SUN to hinder mySQL's development. It is now a very good a free database and I am sure oracle would have been getting worried since it added in stored procs.

There were quite a few conditions that Oracle had to commit to before being allowed to complete the takeover. Oracle will be investing more in R&D for MySQL than Sun ever did, by some way.

The guy that came up with the MySQL idea (who then sold it to Sun and moaned when Sun was a takeover target that it was being sold on to a big corporation) was working on another project as well, which looked quite interesting. I can't remember what it's called now though.

[TheFaQQer]

MySQL has in-line views now:

mysql> select * from (select 1 from dual) x;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Does MySQL allow you to insert into DUAL to totally screw up the database, though? Oracle does

[Sysman]

The guy that came up with the MySQL idea (who then sold it to Sun and moaned when Sun was a takeover target that it was being sold on to a big corporation) was working on another project as well, which looked quite interesting. I can't remember what it's called now though.

A chap who goes by the moniker of Monty. His Wiki entry.

Monty is currently working on a branch of the MySQL code base with the Aria storage engine. The product is known affectionately as MariaDB, named after his youngest daughter. MariaDB is a product of Monty Program AB

[Durbs]

A chap who goes by the moniker of Monty. His Wiki entry.

MySQL was named after his other daugher My. Didn't know that, I thought it was named that to appear friendly and approachable.

[Sysman]

MySQL was named after his other daugher My. Didn't know that, I thought it was named that to appear friendly and approachable.

I'd missed that bit. In fact the earliest book I bought on MySQL also covered a lighter weight one called mSQL.

mSQL was the first low-cost SQL-based database management system. Combined with the free Linux operating system, the availability of relatively-powerful low-cost PC hardware, and the development of world wide web standards and technologies, mSQL was an important factor in the early development of interactive, dynamic web applications[3], particularly in the period 1994-1997, after which it was increasingly supplanted by the more highly featured MySQL. mSQL had a large and widespread install base by the late 1990s[4].