SELECT CONCAT( "[", GROUP_CONCAT( CONCAT("{name:'",`name`,"'"), CONCAT(",email:'",`email`,"'}") ) ,"]") AS json FROM users; CREATE TABLE `user`( `id` int not null auto_increment, `name` varchar(100), `email` varchar(50), PRIMARY KEY(id) ) ENGINE = InnoDB; INSERT INTO `user` (`name`, `email`) VALUES ('Cesar', 'cesar@craftyman.net'), ('Maria', 'maria@gmail.com'), ('Jose', 'j0s3@hotmail.com'), ('Albert','albertpr@yahoo.com');

This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff involved in a MySQL to DB2 UDB conversion project.

This redbook also provides step-by-step instructions for installing and using the IBM DB2 Migration Toolkit (MTK) to port the database objects and data from MySQL to DB2 UDB.

Application programming and conversion considerations are discussed along with the differences in features and functionality of MySQL and DB2 UDB.

Examples are used throughout the book to illustrate conversions of database access, database administration, SQL statements (DDL, DML) and others, as well as testing and tuning your DB2 UDB system.

Loading up a new laptop I downloaded and ran Uniform Server 4.2-Mona and everything worked just fine.

A few days ago I tried to start up the server and it failed, being unable to find redirect.html on drive z:

Inserting some pauses in a copy of Server_Start.bat is discovered that after uniserv.exe ran, z: disappeared.

Some searching around got me to:
http://wiki.uniformserver.com/index.php/Ne...s_Section#Skype

I closed Skype and everything worked great.

I've been using Uniform Server for years and have been very happy with it.

Many thanks!

-Michael

This presents you with various categories of gadgets to choose from (similar to the iGoogle directory). My gadget isn't yet in the gallery, so you'll need to select "Custom" and then type in the URL to the gadget:

via http://twitter.com/timoreilly/status/1724767013

Memcached will dramatically speed up MediaWiki. Some pages on my site, like the Main Page took 40 seconds to load before Memcached, but only 7 after installing Memcached. "Memcached is a high-performance, distributed memory object caching system". Memcached is essentially a database caching system which is object orientated, and works even if the database is updated. (MySQL caching discards the entire cache when a table is changed)

I'm Michael Plasmeier otherwise known as ThePlaz. I am a senior at Haverford High School as well as a web developer and project manager with a focus on user experience and design. I am also a TV Show producer and host and an open source app maintainer. Next year, I will be attending the Massachusetts Institute of Technology (MIT). See Why MIT for more.

"Details In MySQL, our entities are stored in a table that looks like this: CREATE TABLE entities ( added_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, id BINARY(16) NOT NULL, updated TIMESTAMP NOT NULL, body MEDIUMBLOB, UNIQUE KEY (id), KEY (updated) ) ENGINE=InnoDB; For example, a typical entity in FriendFeed might look like this: { "id": "71f0c4d2291844cca2df6f486e96e37c", "user_id": "f48b0440ca0c4f66991c4d5f6a078eaf", "feed_id": "f48b0440ca0c4f66991c4d5f6a078eaf", "title": "We just launched a new backend system for FriendFeed!", "link": "http://friendfeed.com/e/71f0c4d2-2918-44cc-a2df-6f486e96e37c", "published": 1235697046, "updated": 1235697046, } "

Lots of detail about building the site. A feed or a program is a URL and I don't want to isolate my podcast urls from my other urls, so I'll stick with del.icio.us.