在MySQL监视器中阅读MySQL手册？

Problem: To read MySQL's manual effectively

问题:有效阅读MySQL的手册

Error:

mysql> create database plastronics
    -> ;
ERROR 1007 (HY000): Can't create database 'plastronics'; database exists
mysql>

Question: How do I check it quickly like in Vim: ":h 1007"?

问题:如何在Vim中快速检查:“:h 1007”?

The introduction material I was reading

我正在阅读的介绍材料

2 个解决方案

#1

A list of error messages is available on the MySQL website. However, it isn't really going to help you if the error the server spit out didn't.

MySQL网站上提供了错误消息列表。但是,如果服务器吐出的错误没有帮助你,它实际上不会帮助你。

You asked MySQL to create a database; MySQL replied that it can't create that database because it already exists. You can't have two databases on the same server with the same name. You need to either pick a different name (e.g., create database plastronics2) or drop the already-existing database (drop database plastronics).

你要求MySQL创建一个数据库; MySQL回复称它无法创建该数据库,因为它已经存在。您不能在同一服务器上具有两个具有相同名称的数据库。您需要选择一个不同的名称(例如,创建数据库plastronics2)或删除已存在的数据库(drop database plastronics)。

Please beware that dropping a database destroys everything in it (tables, views, procedures, all the data, etc.)

请注意,删除数据库会破坏其中的所有内容(表,视图,过程,所有数据等)

Looking at the tutorial you linked, it appears it shows the same create database statement twice in a row. I suspect you just entered the statement twice, instead of once as the tutorial's author intended.

查看您链接的教程,它似乎连续两次显示相同的create database语句。我怀疑你刚刚进入两次声明,而不是教程作者的意图。

#2

Solution to your problem

解决您的问题

Make a Vim-like K button for MySQL in Screen. Note that it is not possible to put all manuals under K.

在屏幕上为MySQL制作类似Vim的K按钮。请注意,不能将所有手册放在K下。

Practical solution

Download MySQL manuals to your computer. (not sure whether Sun gives zip-files of them)

将MySQL手册下载到您的计算机上。 (不确定Sun是否提供了zip文件)

make a binding Ctrl-A Esc Ctrl-m for instance for Mysql's manuals in .screenrc

例如,为.bsrc中的Mysql手册创建一个绑定Ctrl-A Esc Ctrl-m

Please, search/read Screen's manual for more info by

请搜索/阅读屏幕手册以获取更多信息

man screen

or by pinfo

或者通过pinfo

pinfo screen

#1