Problem: to read effectively MySQL's manual
Error:
mysql> create database plastronics
-> ;
ERROR 1007 (HY000): Can't create database 'plastronics'; database exists
mysql>
Question: How to check it quickly like in VIM: ":h 1007"?
Problem: to read effectively MySQL's manual
Error:
mysql> create database plastronics
-> ;
ERROR 1007 (HY000): Can't create database 'plastronics'; database exists
mysql>
Question: How to check it quickly like in VIM: ":h 1007"?
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.
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
).
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.
Solution to your problem
Practical solution
Ctrl-A Esc Ctrl-m
for instance for Mysql's manuals in .screenrcPlease, search/read Screen's manual for more info by
man screen
or by pinfo
pinfo screen