fill_help_tables.sql

开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

insert into help_category (help_category_id,name,parent_category_id,url) values (9,"Account Management",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (10,"Point properties",31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (11,"Encryption Functions",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (12,"LineString properties",31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (13,"Logical operators",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (14,"Miscellaneous Functions",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (15,"Functions and Modifiers for Use with GROUP BY",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (16,"Information Functions",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (17,"Storage Engines",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (18,"Comparison operators",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (19,"Bit Functions",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (20,"Table Maintenance",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (21,"Data Types",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (22,"Triggers",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (23,"Geometry constructors",31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (24,"GeometryCollection properties",1,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (25,"Administration",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (26,"Data Manipulation",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (27,"Geometry relations",31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (28,"Language Structure",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (29,"Date and Time Functions",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (30,"WKB",31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (31,"Geographic Features",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (32,"Contents",0,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (33,"Geometry properties",31,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (34,"String Functions",35,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (35,"Functions",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (36,"Stored Routines",32,'');
insert into help_category (help_category_id,name,parent_category_id,url) values (37,"Data Definition",32,'');

insert into help_topic (help_topic_id,help_category_id,name,description,example,url) values (0,26,"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]\n        [{USE|IGNORE|FORCE} INDEX (key_list)]\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\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 JOIN is used otherwise.\n\nIn general, parentheses can be ignored in join expressions containing\nonly inner join operations. MySQL also supports nested joins (see\n[nested-joins]).\n","SELECT table1.* FROM table1\n  LEFT JOIN table2 ON table1.id=table2.id\n  WHERE table2.id IS NULL;\n","join");