-- Copyright (C) 2000-2008 MySQL AB
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; version 2 of the License.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-- DO NOT EDIT THIS FILE. It is generated automatically.
-- To use this file, load its contents into the mysql database. For example,
-- with the mysql client program, process the file like this, where
-- file_name is the name of this file:
-- mysql -u root -p mysql < file_name
set names 'utf8';
delete from help_topic;
delete from help_category;
delete from help_keyword;
delete from help_relation;
insert into help_category (help_category_id,name,parent_category_id,url) values (1,'Geographic',0,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (2,'Polygon properties',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (3,'WKT',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (4,'Numeric Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (5,'MBR',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (6,'Control flow functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (7,'Transactions',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (8,'Account Management',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (9,'Point properties',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (10,'Encryption Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (11,'LineString properties',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (12,'Logical operators',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (13,'Miscellaneous Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (14,'Functions and Modifiers for Use with GROUP BY',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (15,'Information Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (16,'Storage Engines',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (17,'Comparison operators',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (18,'Bit Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (19,'Table Maintenance',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (20,'Data Types',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (21,'Triggers',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (22,'Geometry constructors',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (23,'GeometryCollection properties',1,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (24,'Administration',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (25,'Data Manipulation',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (26,'Geometry relations',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (27,'Language Structure',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (28,'Date and Time Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (29,'WKB',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (30,'Geographic Features',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (31,'Contents',0,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (32,'Geometry properties',30,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (33,'String Functions',34,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (34,'Functions',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (35,'Stored Routines',31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (36,'Data Definition',31,'');
insert into help_topic (help_topic_id,help_category_id,name,description,example,url) values (0,14,'MIN','Syntax:\nMIN([DISTINCT] expr)\n\nReturns the minimum value of expr. MIN() may take a string argument; in\nsuch cases, it returns the minimum string value. See\nhttp://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html. The DISTINCT\nkeyword can be used to find the minimum of the distinct values of expr,\nhowever, this produces the same result as omitting DISTINCT.\n\nMIN() returns NULL if there were no matching rows.\n\nURL: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html\n\n','mysql> SELECT student_name, MIN(test_score), MAX(test_score)\n -> FROM student\n -> GROUP BY student_name;\n','http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html');
insert into help_topic (help_topic_id,help_category_id,name,description,example,url) values (1,25,'JOIN','MySQL supports the following JOIN syntaxes for the table_references\npart of SELECT statements and multiple-table DELETE and UPDATE\nstatements:\n\ntable_references:\n table_reference [, table_reference] ...\n\ntable_reference:\n table_factor\n | join_table\n\ntable_factor:\n tbl_name [[AS] alias] [index_hint)]\n | ( table_references )\n | { OJ table_reference LEFT OUTER JOIN table_reference\n ON conditional_expr }\n\njoin_table:\n table_reference [INNER | CROSS] JOIN table_factor [join_condition]\n | table_reference STRAIGHT_JOIN table_factor\n | table_reference STRAIGHT_JOIN table_factor ON condition\n | table_reference LEFT [OUTER] JOIN table_reference join_condition\n | table_reference NATURAL [LEFT [OUTER]] JOIN table_factor\n | table_reference RIGHT [OUTER] JOIN table_reference join_condition\n | table_reference NATURAL [RIGHT [OUTER]] JOIN table_factor\n\njoin_condition:\n ON conditional_expr\n | USING (column_list)\n\nindex_hint:\n USE {INDEX|KEY} [FOR JOIN] (index_list)\n | IGNORE {INDEX|KEY} [FOR JOIN] (index_list)\n | FORCE {INDEX|KEY} [FOR JOIN] (index_list)\n\nindex_list:\n index_name [, index_name] ...\n\nA table reference is also known as a join expression.\n\nThe syntax of table_factor is extended in comparison with the SQL\nStandard. The latter accepts only table_reference, not a list of them\ninside a pair of parentheses.\n\nThis is a conservative extension if we consider each comma in a list of\ntable_reference items as equivalent to an inner join. For example:\n\nSELECT * FROM t1 LEFT JOIN (t2, t3, t4)\n ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)\n\nis equivalent to:\n\nSELECT * FROM t1 LEFT JOIN (t2 CROSS JOIN t3 CROSS JOIN t4)\n ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)\n\nIn MySQL, CROSS JOIN is a syntactic equivalent to INNER JOIN (they can\nreplace each other). In standard SQL, they are not equivalent. INNER\nJOIN is used with an ON clause, CROSS
没有合适的资源?快使用搜索试试~ 我知道了~
mysql5-uninstall
共128个文件
xml:25个
sys:24个
frm:17个
5星 · 超过95%的资源 需积分: 9 11 下载量 106 浏览量
2010-03-03
07:53:05
上传
评论
收藏 6.13MB RAR 举报
温馨提示
mysql5免安装文件 mysql5免安装文件 mysql5免安装文件 mysql5免安装文件
资源推荐
资源详情
资源评论
收起资源包目录
mysql5-uninstall (128个子文件)
COPYING 19KB
cs.err 49KB
china-7525e46d0.err 2KB
EXCEPTIONS-CLIENT 5KB
mysqld-nt.exe 5.48MB
mysql.exe 1.96MB
mysqldump.exe 1.95MB
mysqladmin.exe 1.91MB
mysqlimport.exe 1.9MB
user.frm 10KB
proc.frm 9KB
db.frm 9KB
host.frm 9KB
tables_priv.frm 9KB
procs_priv.frm 9KB
columns_priv.frm 9KB
help_topic.frm 9KB
time_zone_transition_type.frm 9KB
help_category.frm 8KB
time_zone_transition.frm 8KB
func.frm 8KB
time_zone.frm 8KB
help_relation.frm 8KB
time_zone_leap_second.frm 8KB
help_keyword.frm 8KB
time_zone_name.frm 8KB
languages.html 16KB
ib_logfile0 10MB
ib_logfile1 10MB
ibdata1 26MB
my-innodb-heavy-4G.ini 21KB
my-template.ini 13KB
my.ini 9KB
my-huge.ini 5KB
my-medium.ini 5KB
my-large.ini 5KB
my-small.ini 2KB
help_topic.MYD 339KB
help_keyword.MYD 77KB
help_category.MYD 20KB
help_relation.MYD 7KB
db.MYD 876B
user.MYD 420B
procs_priv.MYD 0B
time_zone_name.MYD 0B
time_zone.MYD 0B
time_zone_transition_type.MYD 0B
func.MYD 0B
time_zone_leap_second.MYD 0B
tables_priv.MYD 0B
host.MYD 0B
time_zone_transition.MYD 0B
columns_priv.MYD 0B
proc.MYD 0B
help_topic.MYI 17KB
help_relation.MYI 16KB
help_keyword.MYI 14KB
db.MYI 4KB
help_category.MYI 3KB
user.MYI 2KB
columns_priv.MYI 1024B
func.MYI 1024B
time_zone_name.MYI 1024B
tables_priv.MYI 1024B
procs_priv.MYI 1024B
time_zone_leap_second.MYI 1024B
proc.MYI 1024B
host.MYI 1024B
time_zone_transition_type.MYI 1024B
time_zone.MYI 1024B
time_zone_transition.MYI 1024B
cs.pid 4B
README 2KB
fill_help_tables.sql 488KB
mysql_fix_privilege_tables.sql 31KB
mysql_system_tables_fix.sql 19KB
mysql_system_tables.sql 12KB
mysql_test_data_timezone.sql 9KB
mysql_system_tables_data.sql 1KB
errmsg.sys 31KB
errmsg.sys 29KB
errmsg.sys 28KB
errmsg.sys 28KB
errmsg.sys 28KB
errmsg.sys 28KB
errmsg.sys 28KB
errmsg.sys 28KB
errmsg.sys 28KB
errmsg.sys 27KB
errmsg.sys 27KB
errmsg.sys 27KB
errmsg.sys 27KB
errmsg.sys 27KB
errmsg.sys 27KB
errmsg.sys 26KB
errmsg.sys 26KB
errmsg.sys 26KB
errmsg.sys 26KB
errmsg.sys 26KB
errmsg.sys 26KB
共 128 条
- 1
- 2
资源评论
- fighting_rabbit2012-11-15绿色版mysql 解压后只需添加环境变量 想要删除 只需去掉环境变量 再删除解压文件夹即可 谢谢分享
computersir
- 粉丝: 2
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功