摘要:登录mysql –u username –p password,查看数据库show databases,切换数据库use databasename,查看表show tables,查看表结构describe tablename或show columns from tablename,创建表语句show create table tablename。 时间处理:存为字符串的long型时间通常是15个... 阅读全文
posted @ 2011-06-17 15:21 xlongwei 阅读 (85) 评论 (0) 编辑
摘要:1. 查询:select column from table where condition group by column having condition order by column limit start,end a) 去掉重复:select disdinct column from table b) 条件:select column from table where condition... 阅读全文
posted @ 2011-06-17 14:56 xlongwei 阅读 (116) 评论 (0) 编辑
xlongwei