More than 5 years have passed since last update.

MySQLのSQLをtokenizeするRubyの正規表現

Ruby
MySQL
SQL

Last updated at 2015-09-11Posted at 2015-09-11

mysqldumpしたSQLをparseするための自分メモ

sql = <<__SQL__
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `restaurant_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_users_on_email` (`email`),
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
__SQL__
p sql.scan(/(?:''|(?:'.*?[^']'(?!'))|`.*?`|-?\d+(?:\.\d+)?|\w+|\S)/m)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up