Skip to content

Instantly share code, notes, and snippets.

@rcreasey
Created February 12, 2011 17:37
Show Gist options
  • Select an option

  • Save rcreasey/823900 to your computer and use it in GitHub Desktop.

Select an option

Save rcreasey/823900 to your computer and use it in GitHub Desktop.
Trying to figure out what's happening when doing a db pull from one mysql db to another.
mysql> explain wp_users;
+---------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------------------+----------------+
| ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| user_login | varchar(60) | NO | MUL | | |
| user_pass | varchar(64) | NO | | | |
| user_nicename | varchar(50) | NO | MUL | | |
| user_email | varchar(100) | NO | | | |
| user_url | varchar(100) | NO | | | |
| user_registered | datetime | NO | | 0000-00-00 00:00:00 | |
| user_activation_key | varchar(60) | NO | | | |
| user_status | int(11) | NO | | 0 | |
| display_name | varchar(250) | NO | | | |
+---------------------+---------------------+------+-----+---------------------+----------------+
10 rows in set (0.00 sec)
/Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:91:in `query': Mysql2::Error: Incorrect column specifier for column 'ID' (Sequel::DatabaseError)
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:91:in `block in _execute'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/logging.rb:28:in `log_yield'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:91:in `_execute'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:74:in `block in execute'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/connection_pool/threaded.rb:84:in `hold'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/connecting.rb:226:in `synchronize'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:74:in `execute'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/query.rb:71:in `execute_dui'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/query.rb:64:in `execute_ddl'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/schema_methods.rb:320:in `create_table_from_generator'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/schema_methods.rb:94:in `create_table'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/extensions/migration.rb:52:in `method_missing'
from (eval):3:in `up'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/extensions/migration.rb:33:in `apply'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/taps-0.3.15/lib/taps/schema.rb:64:in `block in load'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/connecting.rb:76:in `connect'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/core.rb:119:in `connect'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/taps-0.3.15/lib/taps/schema.rb:61:in `load'
from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/taps-0.3.15/bin/schema:44:in `<main>'
Class.new(Sequel::Migration) do
def up
create_table("wp_users") do
primary_key :ID, :type=>String
String :user_login, :null=>false, :size=>60
String :user_pass, :null=>false, :size=>64
String :user_nicename, :null=>false, :size=>50
String :user_email, :null=>false, :size=>100
String :user_url, :null=>false, :size=>100
DateTime :user_registered, :null=>false
String :user_activation_key, :null=>false, :size=>60
Integer :user_status, :default=>0, :null=>false
String :display_name, :null=>false, :size=>250
end
end
def down
drop_table("wp_users") if @db.table_exists?("wp_users")
end
end
SELECT * FROM `wp_users` LIMIT 1
CREATE TABLE `wp_users` (`ID` varchar(255) PRIMARY KEY AUTO_INCREMENT, `user_login` varchar(60) NOT NULL, `user_pass` varchar(64) NOT NULL, `user_nicename` varchar(50) NOT NULL, `user_email` varchar(100) NOT NULL, `user_url` varchar(100) NOT NULL, `user_registered` datetime NOT NULL, `user_activation_key` varchar(60) NOT NULL, `user_status` integer NOT NULL DEFAULT 0, `display_name` varchar(250) NOT NULL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment