Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +----------------+--------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +----------------+--------------+------+-----+---------+-------+
- | item_name | varchar(255) | NO | | NULL | |
- | item_link | varchar(50) | NO | PRI | NULL | |
- | item_price | varchar(10) | NO | | NULL | |
- | shop_name | varchar(40) | NO | MUL | NULL | |
- | sales | int(11) | NO | | NULL | |
- | sale_date | varchar(10) | NO | PRI | NULL | |
- +----------------+--------------+------+-----+---------+-------+
- key_buffer = 16M
- max_allowed_packet = 16M
- sort_buffer_size = 8M
- net_buffer_length = 8K
- read_buffer_size = 2M
- read_rnd_buffer_size = 16M
- myisam_sort_buffer_size = 8M
- log_error = "mysql_error.log"
- innodb_autoinc_lock_mode=0
- join_buffer_size = 8M
- thread_cache_size = 8
- thread_concurrency = 8
- query_cache_size = 64M
- query_cache_limit = 2M
- ft_min_word_len = 4
- thread_stack = 192K
- tmp_table_size = 64M
- innodb_buffer_pool_size = 1.5G
- innodb_additional_mem_pool_size = 16M
- innodb_log_file_size = 350M
- innodb_log_buffer_size = 8M
- innodb_flush_log_at_trx_commit = 1
- innodb_lock_wait_timeout = 120
- innodb_write_io_threads = 8
- innodb_read_io_threads = 8
- innodb_thread_concurrency = 16
- innodb_log_files_in_group = 3
- innodb_max_dirty_pages_pct = 90
- SELECT item_name,
- item_link,
- item_price,
- shop_name,
- sales
- FROM `sales`
- WHERE sale_date = '2019-04-18'
- SELECT item_name,
- item_link,
- item_price,
- shop_name,
- Sum(sales) AS sales
- FROM `sales`
- WHERE sale_date BETWEEN '2019-04-17' AND '2019-04-18'
- GROUP BY item_link
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement