操作SQL数据
最近忙与看java方面的知识,却忽视了sql,今天笔试中有几道题!于是总结一 下,便于学习和查询.
1.插入数据
insert into tableName values(....)
2.删除数据
delete from tableName [where_definition][limit rows]
3.更新数据
update tableName set col_name=expr1,....[where_definition][limit rows]
4.数据查询
select * from tableName [where_definition]
5.排序
select * from tableName order by XXX desc/asc
6.运用limit字句进行限制输出结果
select * from tableName order by XXX desc/asc limit 5
未完待续
1.插入数据
insert into tableName values(....)
2.删除数据
delete from tableName [where_definition][limit rows]
3.更新数据
update tableName set col_name=expr1,....[where_definition][limit rows]
4.数据查询
select * from tableName [where_definition]
5.排序
select * from tableName order by XXX desc/asc
6.运用limit字句进行限制输出结果
select * from tableName order by XXX desc/asc limit 5
未完待续
Jason
2005-04-18 20:52:55
评论:1
阅读:892
引用:0
无题
@2005-04-21 19:19:37 xiaosheng
昨天晚上我看到了数据库的左连接与右连接,可没怎么关注,今天面试竟然问左连接与右连接的区别!