What to do if error code 1064 occurs in mysql

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;].

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

#2. Then enter one of the databases.

SHOW DATABASES;
USE testdb;

3,

SELECT * FROM branch;

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

4,

SELET * FROM branch;

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

5,

SELECT * FORM branch;

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

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!