博主不想写字并向你仍来了一堆代码 1-6SQL——结构化查询语言,Structured Query Language;基本按列查询:mysql> SELECT prod_id,prod_name,prod_desc -> ...
博主不想写字并向你仍来了一堆代码
1-6
SQL——结构化查询语言,Structured Query Language;
基本按列查询:
mysql> SELECT prod_id,prod_name,prod_desc -> FROM products -> ORDER BY prod_id;+---------+---------------------+-----------------------------------------------------------------------+| prod_id | prod_name | prod_desc |+---------+---------------------+-----------------------------------------------------------------------+| BNBG01 | Fish bean bag toy | Fish bean bag toy, complete with bean bag worms with which to feed it || BNBG02 | Bird bean bag toy | Bird bean bag toy, eggs are not included || BNBG03 | Rabbit bean bag toy | Rabbit bean bag toy, comes with bean bag carrots || BR01 | 8 inch teddy bear | 8 inch teddy bear, comes with cap and jacket || BR02 | 12 inch teddy bear | 12 inch teddy bear, comes with cap and jacket || BR03 | 18 inch teddy bear | 18 inch teddy bear, comes with cap and jacket || RGAN01 | Raggedy Ann | 18 inch Raggedy Ann doll || RYL01 | King doll | 12 inch king doll with royal garments and crown || RYL02 | Queen doll | 12 inch queen doll with royal garments and crown |+---------+---------------------+-----------------------------------------------------------------------+
原标题:SQL必知必会1
关键词:sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。