- 博客(4)
- 收藏
- 关注
RSS订阅原创 mysql查询或更新单双数字的内容
select * from tbl_name where userid%2=1 mysql> select * from message_bak; +----+-----------+--------------------+---------------------+ | id | name | content | time ...
2013-11-19 17:27:38
289
原创 mysql复制表结构或者表数据，可备份数据
If the destination table already exists, use INSERT ... SELECT to copy the result set into it. For example, if dst_tbl contains an integer column i and a string column s, the following statement copi...
2013-11-19 17:26:05
122
原创 sql插入默认值为当前时间
mysql> desc message; +---------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-------...
2013-11-13 17:24:27
2612
原创 sql查询最后一条自增长的记录
mysql> select * from message where id = (select max(id) from message); +----+------+---------+---------------------+ | id | name | content | time | +----+------+---------+-------...
2013-11-13 17:21:27
592
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人