links for 2009-08-10

August 11, 2009
  • <blockquote>
    <pre>
    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');
    </pre>
    </blockquote>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: