2018年6月27日
mysql: aggregation
摘要： /*************** * Aggregation * ***************/ -- Find minimum msrp of all products select min(msrp) from product; -- Find maximum msrp of all products select max(msrp) from product; -- Top ... 阅读全文
posted @ 2018-06-27 23:45 miaomiaotab 阅读(243) 评论(0) 推荐(0)
mysql: join
摘要： /*************** * join tables * ***************/ -- list all sales for FLEX and BLAZE; select * from product; select * from sales; -- what happens without a.product_id=b.product_id; -- use table... 阅读全文
posted @ 2018-06-27 22:55 miaomiaotab 阅读(127) 评论(0) 推荐(0)
mysql: query
摘要： USE fitbit_new; insert into product (product_id, code, name, color, class, msrp) values (5, 'np1', 'new product 1', 'PINK','EVERYDAY', 49), (6, 'np2', 'new product 2', 'PINK','EVERYDAY', 29), (7, 'n... 阅读全文
posted @ 2018-06-27 17:09 miaomiaotab 阅读(195) 评论(0) 推荐(0)
mysql: create database
摘要： /*************************************** * DDL: Create Database * ***************************************/ -- drop existing database if exists; DROP DATABASE IF EXISTS fitbit_new;... 阅读全文
posted @ 2018-06-27 16:15 miaomiaotab 阅读(1730) 评论(0) 推荐(0)