mysql 批量构造模拟数据

最新推荐文章于 2024-04-22 09:52:50 发布

原创

最新推荐文章于 2024-04-22 09:52:50 发布 · 2.5k 阅读

5 ·

CC 4.0 BY-SA版权

1、创建存储过程

-- 创建存储过程
DELIMITER $$ 
create procedure insert_tophatter_record(n int)
begin
declare i int default 0;
set autocommit = 0;
repeat
set i = i + 1;
INSERT INTO `ueb_tophatter_list` (`account`, `sku`, `sku_identifier`, `internal_id`, `category`, `title`, `description`, `condition`, 
`is_multi`, `brand`, `material`, `retail_price`, `cost_basis`, `minimum_bid_amount`, `scheduling_fee_bid`, 
`max_daily_schedules`, `shipping_price`, `shipping_origin`, `weight`, `days_to_fulfill`, 
`days_to_deliver`, `expedited_shipping_price`, `expedited_days_to_deliver`, `buy_one_get_one_price`, 
`primary_image`, `extra_images`, `available_quantity`, `all_images_json`, `ratings_count`, `ratings_average`, 
`created_at`, `updated_at`, `disabled_at`, `deleted_at`, `catalog_only_at`, `created_in`, `created_by`, `updated_in`, 
`updated_by`, `status`, `publish_in`, `publish_data_url`, `error_remark`) 
VALUES ('19951103', 'JM10697', 'JM10697_20181205152406_1217', '18204119', 'Accessories