Jack Wallen explains how to add data into a MySQL table from the command line.

The MySQL Workbench GUI is cross-platform, open source, and incredibly easy to use.

In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.

In what is probably a surprise to many developers, MySQL currently stores its critical system tables in MyISAM instead of InnoDB. Since MyISAM isn’t ACID compliant, there is a chance for data ...