摘要:
使用比较运算符的子查询 符号:=,>,,!=, 例子:SELECT goods_id,goods_name,goods_price FROM tdb_goods WHERE goods_price > (SELECT AVG(goods_price) AS avg_price FROM... 阅读全文
摘要:
插入记录 语法:INSERT [INTO] [(tbl_name,...)] {VALUE|VALUE} ({expr|DEFAULT},...),(...),... 例子: 给所有的列都插入数据 INSERT student VALUES('1','Tom','123') ... 阅读全文