1.rails g scaffold user name:string phone:string 创建一个用户mvc框架的脚手架
2.rails g migration rename_end_time_to_over_time 修改数据库的字段名
迁移rb文件
# -*- encoding : utf-8 -*-
class RenameEndTimeToOverTime < ActiveRecord::Migration
def change
rename_column :mall_brands_offs, :end_time, :over_time
end
end
3.rails g migtration add_end_time_to_表明 为数据库增加字段
迁移的rb文件
# -*- encoding : utf-8 -*-
class AddOrderNumToMallProductCatagories < ActiveRecord::Migration
def change
add_column :mall_product_catagories, :order_num, :integer
end
end
4.rails g migration change_表名_type_to_start_time 修改数据库的字段类型
迁移rb文件:
class ChangeMallbrandsoffTypeToStartTime < ActiveRecord::Migration
def change
change_column :mall_brands_offs, :start_time, :datetime
end
end
4.rails d scaffold user 删除生成的脚手架
5.查询数据库: User.all (返回全部) User.find(通过id) User.select(:brand).distinct ( 通过brand品牌返回全部结果并且去除重复)