Posted By

eddequincey on 07/22/11


Tagged

mysql sql api twitter


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

freaktheclown
Beppoi


SQL Query to create a table in MySQL to store tweets


 / Published in: SQL
 

  1. CREATE TABLE `tweets` (
  2. `id` bigint(20) NOT NULL,
  3. `created_at` datetime NOT NULL,
  4. `from_user` varchar(100) NOT NULL,
  5. `from_user_id` bigint(20) NOT NULL,
  6. `text` text NOT NULL,
  7. `source` text NOT NULL,
  8. `geo` varchar(100) NOT NULL,
  9. `iso_language_code` varchar(10) NOT NULL,
  10. `profile_image_url` varchar(100) NOT NULL,
  11. `to_user_id` bigint(20) NOT NULL,
  12. `query` text NOT NULL,
  13. PRIMARY KEY (`id`)
  14. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Report this snippet  

You need to login to post a comment.