Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

更新语法帮助功能 #800

Open
jd-zhang opened this issue Jul 12, 2022 · 4 comments
Open

更新语法帮助功能 #800

jd-zhang opened this issue Jul 12, 2022 · 4 comments

Comments

@jd-zhang
Copy link
Contributor

*Issue migrated from trac ticket # 898 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-12 14:31:23: smith created the issue


将新增的语法补充到语法查阅函数中,分别有:

help;
insert ignore;
insert ... on duplicate key update;
update/delete ... order by ... limit ...;
replace into 

例如查阅show和replace语法

mysql> \h show
Name: 'SHOW'
Description:
show the value of a run-time parameter
Examples:
SHOW name
SHOW ALL
SHOW DATABASES
SHOW SCHEMAS
SHOW TABLES
SHOW PROCESSLIST

mysql> \h replace
Name: 'REPLACE'
Description:
If the old row in the table has a unique constraint violation with the new row, the old row in the table is replaced; otherwise, the new row is inserted.
Examples:
[ WITH [ RECURSIVE ] with_query [, ...] ]
REPLACE INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
    [ OVERRIDING { SYSTEM | USER} VALUE ]
    { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
    [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

mysql>
@jd-zhang
Copy link
Contributor Author

2022-07-12 14:31:31: smith changed component from DBA GUI to computing nodes

@jd-zhang
Copy link
Contributor Author

2022-07-12 14:31:31: smith

@jd-zhang
Copy link
Contributor Author

2022-07-12 14:31:31: smith changed owner from fangfang to smith

@jd-zhang
Copy link
Contributor Author

2022-07-12 14:31:37: smith changed status from new to accepted

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant