随机生成id
解决方案 »
- sql能删除含有数字的列吗
- mysql C 数据类型转换
- MySQL建表出错~~
- MySQL DBA 群 54609593
- Mysql 我这样的多表查询如何提高速度 ?
- 兄弟们。。救我。为什么mysql中text是乱码,改成varchar就不是乱码???
- 求一句SQL语句!
- 如何设置默认值为当前的系统时间 ??
- 做mysql的中文化,大家一起帮忙呀!帮忙翻一下!
- MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout ex
- mysql 存储过程里面 如何对所有异常做一个统一的处理呢?
- 如何统计mysql字段中有多少个分号?
+-----------------------------+
| cast(rand()*100 as SIGNED ) |
+-----------------------------+
| 44 |
+-----------------------------+
1 row in set (0.01 sec)mysql> select cast(rand()*100 as SIGNED );
+-----------------------------+
| cast(rand()*100 as SIGNED ) |
+-----------------------------+
| 27 |
+-----------------------------+
1 row in set (0.00 sec)mysql> select cast(rand()*100 as SIGNED );
+-----------------------------+
| cast(rand()*100 as SIGNED ) |
+-----------------------------+
| 1 |
+-----------------------------+
1 row in set (0.00 sec)