Skip to content

Instantly share code, notes, and snippets.

@myabc
Created April 24, 2010 13:24
Show Gist options
  • Save myabc/377647 to your computer and use it in GitHub Desktop.
Save myabc/377647 to your computer and use it in GitHub Desktop.
~ (0.034) DROP TABLE IF EXISTS `posts`
~ (0.015) com.mysql.jdbc.PreparedStatement@15ede11: SHOW TABLES LIKE 'posts'
~ (0.001) com.mysql.jdbc.PreparedStatement@3d511e: SHOW VARIABLES LIKE 'character_set_connection'
~ (0.001) com.mysql.jdbc.PreparedStatement@d41f3: SHOW VARIABLES LIKE 'collation_connection'
~ (0.771) CREATE TABLE `posts` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(50), `body` TEXT, `created_at` DATE, PRIMARY KEY(`id`)) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-24')
~ (0.016) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-23')
~ (0.009) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-22')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-21')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-20')
~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-19')
~ (0.020) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-18')
~ (0.036) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-17')
~ (0.019) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-16')
~ (0.008) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-15')
~ (0.062) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-14')
~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-13')
~ (0.013) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-12')
~ (0.021) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-11')
~ (0.016) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-10')
~ (0.023) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-09')
~ (0.011) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-08')
~ (0.038) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-07')
~ (0.019) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-06')
~ (0.028) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-05')
~ (0.010) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-04')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-03')
~ (0.011) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-02')
~ (0.029) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-01')
~ (0.010) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-31')
~ (0.021) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-30')
~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-29')
~ (0.027) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-28')
~ (0.026) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-27')
~ (0.017) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-26')
~ (0.019) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-25')
~ (0.030) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-24')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-23')
~ (0.007) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-22')
~ (0.008) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-21')
~ (0.018) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-20')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-19')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-18')
~ (0.011) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-17')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-16')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-15')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-14')
~ (0.026) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-13')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-12')
~ (0.012) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-11')
~ (0.031) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-10')
~ (0.005) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-09')
~ (0.012) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-08')
~ (0.027) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-07')
~ (0.026) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-06')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-05')
~ (0.054) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-04')
~ (0.052) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-03')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-02')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-01')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-28')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-27')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-26')
~ (0.016) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-25')
~ (0.007) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-24')
~ (0.009) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-23')
~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-22')
~ (0.021) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-21')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-20')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-19')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-18')
~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-17')
~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-16')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-15')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-14')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-13')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-12')
~ (0.013) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-11')
~ (0.014) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-10')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-09')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-08')
~ (0.042) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-07')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-06')
~ (0.086) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-05')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-04')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-03')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-02')
~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-01')
~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-31')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-30')
~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-29')
~ (0.000) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-28')
~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-27')
~ (0.012) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-26')
~ (0.023) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-25')
~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-24')
~ (0.034) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-23')
~ (0.037) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-22')
~ (0.008) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-21')
~ (0.009) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-20')
~ (0.013) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-19')
~ (0.020) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-18')
~ (0.030) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-17')
~ (0.006) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-16')
~ (0.020) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-15')
~ (0.030) SELECT `id`, `title`, `created_at` FROM `posts` WHERE `created_at` <= '0019-10-01' ORDER BY `id`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment