mysql 插入递增_关于mysql插入自动递增日期

[code=SQL]

mysql> select * from test;

+----------+------------+

| accessid | createdate |

+----------+------------+

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

| 48 | 2010-11-01 |

+----------+------------+

8 rows in set (0.00 sec)

mysql> set @a=0;

Query OK, 0 rows affected (0.01 sec)

mysql> select accessid, adddate(createdate,interval @a:=@a+1 day) from test;

+----------+-------------------------------------------+

| accessid | adddate(createdate,interval @a:=@a+1 day) |

+----------+-------------------------------------------+

| 48 | 2010-11-02 |

| 48 | 2010-11-03 |

| 48 | 2010-11-04 |

| 48 | 2010-11-05 |

| 48 | 2010-11-06 |

| 48 | 2010-11-07 |

| 48 | 2010-11-08 |

| 48 | 2010-11-09 |

+----------+-------------------------------------------+

8 rows in set (0.00 sec)code]

作者: vipper23

发布时间: 2010-12-14