你的位置:首页 > 软件开发 > 数据库 > SQL必知必会1

SQL必知必会1

发布时间:2016-08-05 18:00:28
博主不想写字并向你仍来了一堆代码 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

sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。