Home>Article>Database> What to do if error code 1064 occurs in mysql

What to do if error code 1064 occurs in mysql

coldplay.xixi
coldplay.xixi Original
2021-03-09 16:47:17 57376browse

Mysql error code 1064 Solution: First enter mysql in command line mode; then enter a database and enter the correct code [SELECT * FROM branch; SELET * FROM branch;].

What to do if error code 1064 occurs in mysql

The operating environment of this tutorial: windows7 system, mysql version 8.0.22, DELL G3 computer.

mysql error code 1064 Solution:

1. First, we enter mysql in command line mode.

mysql -uroot -p

What to do if error code 1064 occurs in mysql

#2. Then enter one of the databases.

SHOW DATABASES; USE testdb;

What to do if error code 1064 occurs in mysql

3,

SELECT * FROM branch;

The error here is the comma and semicolon, which is a common input error.

What to do if error code 1064 occurs in mysql

4,

SELET * FROM branch;

This is because the spelling error of SELECT is missing a C.

What to do if error code 1064 occurs in mysql

5,

SELECT * FORM branch;

This is also a writing error, FORM should be changed to FROM.

What to do if error code 1064 occurs in mysql

Related free learning recommendations:mysql video tutorial

The above is the detailed content of What to do if error code 1064 occurs in mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn