
mysql
iteye_9365
这个作者很懒,什么都没留下…
展开
-
SQL经典查询练手
实例表结构如下CREATE TABLE `emp` ( `EMPNO` int(11) NOT NULL, `ENAME` varchar(45) DEFAULT NULL, `JOB` varchar(45) DEFAULT NULL, `MGR` varchar(45) DEFAULT NULL, `HIREDATE` date DEFAULT NULL,...原创 2013-05-19 16:35:24 · 198 阅读 · 0 评论 -
Mysql命令行导入sql数据
[color=red]mysql> source C:\mysql-5.4.3\cookbook\recipes\tables\mail.sql[/color]Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.01 sec)Query OK, 16 rows affected (0.01 sec...原创 2012-05-09 22:38:57 · 142 阅读 · 0 评论 -
Ubuntu中更改MySQL字符集
在/etc/mysql/my.cnf里添加如下两项[client] default-character-set=utf8 [mysqld] character_set_server=utf8可参考http://gm100861.blog.51cto.com/1930562/896173原创 2013-01-06 22:44:08 · 305 阅读 · 0 评论 -
mysql中创建时间维度
http://blog.youkuaiyun.com/wisgood/article/details/26018613 Small-numbers table DROP TABLE IF EXISTS numbers_small;CREATE TABLE numbers_small (number INT);INSERT INTO numbers_small VALUES (0),(1)...原创 2017-02-14 15:28:40 · 246 阅读 · 0 评论