SQL Query to create a table in MySQL to store tweets

Revision: 49445

at July 22, 2011 00:18 by eddequincey

Initial Code

CREATE TABLE `tweets` (
  `id` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user` varchar(100) NOT NULL,
  `from_user_id` bigint(20) NOT NULL,
  `text` text NOT NULL,
  `source` text NOT NULL,
  `geo` varchar(100) NOT NULL,
  `iso_language_code` varchar(10) NOT NULL,
  `profile_image_url` varchar(100) NOT NULL,
  `to_user_id` bigint(20) NOT NULL,
  `query` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Initial URL

Initial Description

[Query related to PHP code to save tweets from the twitter search API to a MySQL database](http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ "PHP code to save tweets from the twitter search API to a MySQL database")

Initial Title

SQL Query to create a table in MySQL to store tweets

Initial Tags

mysql, sql, api, twitter

Initial Language

SQL

Choose a language for easy browsing: