一共三篇:
管理:http://blog.csdn.net/fenixshadow/archive/2008/02/19/2106554.aspx
开发:http://blog.csdn.net/fenixshadow/archive/2008/02/19/2106546.aspx
安装与配置:http://blog.csdn.net/fenixshadow/archive/2008/02/14/2095956.aspx
请多提意见,谢谢。
管理:http://blog.csdn.net/fenixshadow/archive/2008/02/19/2106554.aspx
开发:http://blog.csdn.net/fenixshadow/archive/2008/02/19/2106546.aspx
安装与配置:http://blog.csdn.net/fenixshadow/archive/2008/02/14/2095956.aspx
请多提意见,谢谢。
开发:http://blog.csdn.net/fenixshadow/archive/2008/02/19/2106546.aspx
安装与配置:http://blog.csdn.net/fenixshadow/archive/2008/02/14/2095956.aspx
做成服务:
linux cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
service mysqld start
SQL> conn 用户名/密码@主机字符串http://blog.chinaunix.net/u/29134/showart_478782.html
MICROSECOND
mySQL 毕竟是Free的
mysql> status;
ERROR 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status' at line 1还有就是我对日期类型的理解不知道对不对:
mysql的Datetime类型就是一个字符串的别名。可以方便的和字符串进行比较、转换 。获取日期的时候系统自动对字符串进行解析。允许2008-00-00这种情况出现。
对于字符串转换为日期比较简单,比如
CREATE TABLE `datetime` ( `dt` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`dt`));
INSERT INTO `datetime` VALUES ('2008-01-01 00:00:00');select * from `datetime`;
回到家里试了一下。status 是显示当前 MYSQL 服务的大概运行情况。
我的测试:
mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.22-rc, for Win32 (ia32)Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.22-rc-community-log MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 12 min 18 secThreads: 1 Questions: 11 Slow queries: 0 Opens: 14 Flush tables: 1 Open tab
les: 7 Queries per second avg: 0.14
--------------mysql>
DATETIME 字段是日期类型,精确到秒。
不过你不能说它是字符串的别名。
毕竟任意字符串是不能存放到里面的。
因为它只认得数字与‘-’(或者其他的分隔符号)手册上面是这么解释的:
DATETIME A date and time combination. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. MySQL displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format, but allows assignment of values to DATETIME columns using either strings or numbers.
The mysqladmin status command result displays the following values: Uptime The number of seconds the MySQL server has been running. Threads The number of active threads (clients). Questions The number of questions (queries) from clients since the server was started. Slow queries The number of queries that have taken more than long_query_time seconds. See Section 5.11.4, “The Slow Query Log”. Opens The number of tables the server has opened. Flush tables The number of flush-*, refresh, and reload commands the server has executed. Open tables The number of tables that currently are open. Memory in use The amount of memory allocated directly by mysqld. This value is displayed only when MySQL has been compiled with --with-debug=full. Maximum memory used The maximum amount of memory allocated directly by mysqld. This value is displayed only when MySQL has been compiled with --with-debug=full.
拿出来讨论下企业版到底有甚么不同
还不是太清楚
mysql> status;
--------------
mysql Ver 14.13 Distrib 5.2.0-falcon-alpha, for Win32 (ia32)Connection id: 2
Current database: fdb
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.2.0-falcon-alpha-community-nt MySQL Community Server (
GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: gb2312
Db characterset: gb2312
Client characterset: gb2312
Conn. characterset: gb2312
TCP port: 3306
Uptime: 2 hours 9 min 41 secThreads: 2 Questions: 139 Slow queries: 0 Opens: 47 Flush tables: 1 Open ta
bles: 0 Queries per second avg: %
mysqlimport.exemysqlimport是load data infile 的客户端工具。所以应该不能与IMP对应。不过我不太清楚IMP是干嘛的。没有用过ORACLE。
增加了日期类型的比较。
explain的生成。
oracle安装注意事项。
完善了导入导出工具的比较。
等等。再次感谢版主。不过select * from information_schema.processlist;在5.0中不行。