周次
參考圖書: https://www.google.com.tw/books/edition/MySQL新手入門超級手冊_第三版/1jSLEAAAQBAJ?hl=zh-TW&gbpv=1&dq=張益裕&printsec=frontcover
程式碼: https://www.gotop.com.tw/books/download.aspx?bookid=AED002931
SELECT name FROM testdb.new_table;
SELECT name FROM testdb.new_table where id = 2;
select product_id, product_name from product;
select * from product;
select *, product_name as ProductName from product;
SELECT name FROM testdb.customer where membertype_id = 2;
SELECT * FROM testdb.customer where id != 3;
SELECT * FROM testdb.product where price < 200;
SELECT * FROM testdb.product where stock = '';